One database or many for multicountry web application -

-

let's different points of view situation have.

i'm creating (asp.net) web application database (sql server express, max 10gb db size).

this application manages entities entities related countries, 1 country - many entities.

before anything, can't predict how db going grow. personal/hobby project i'm doing in free time.

my concerns if should create specific copy of database per country. reasons think are:

  • size of databases smaller, won't have problems of size starting sql server express.
  • again, db size. smaller per country, performance better.
  • can maintenance tasks (backups, deployments) @ low peak time every country.
  • in case of different laws protecting data per country can adapt each db specific law.
  • customized text search per country. not problem because think create view per different country , text search of view.

then, if have 1 database countries there advantages:

  • maintenance going simpler. 1 database means doing things once.
  • no reduntant code. use stored procedures lot of web app. 1 change need published once in production.

god! writing down pros of each alternative seems make multiple database winner! seems single database lazy people...

anyway, i'd read more points of view, please guys, feel free contribute thinkings. thanks!

i choose 1 database.

for easier maintenance work. there 200 countries in world, if have database half of them. day want add column table , have change in every database going nightmare.(making sure don't forget 1 database or if mistype name, etc).

also, power/capacity of current computers, performance shouldn't problem. (unless it's important program).


Comments

Post a Comment

Popular posts from this blog

jasper reports - Fixed header in Excel using JasperReports -

-
how can create excel report fixed header using japserreports? mean need header fixed when scroll excel file. this possible adding couple properties in jrxml file each report. take @ advanced excel features freeze panes. if wanted freeze after first column header (down left side basically) this: <statictext> <reportelement style="sans_bold" mode="opaque" x="0" y="60" width="104" height="20" forecolor="#ffffff" backcolor="#666666"> <property name="net.sf.jasperreports.export.xls.auto.filter" value="start"/> <property name="net.sf.jasperreports.export.xls.column.width" value="110"/> <property name="net.sf.jasperreports.export.xls.freeze.column.edge" value="left"/> </reportelement> &
Read more

media player - Android: mediaplayer went away with unhandled events -

-
i need duration of audio file series of voice announcements need play app. have added audio files resources , play fine. sample code below works perfect intended purpose: return duration of audio files. here code: float getdurationofaudioresource(locationenum loc, context context){ float duration = 0; try { mediaplayer mp; mp = mediaplayer.create(context, getaudioresource(loc)); duration = mp.getduration(); mp.release(); mp = null; } catch (illegalstateexception e) {e.printstacktrace(); logerror(25, "testdescitem:fault::could not open mediaplayer object audio resource.");} return duration; } here's weird thing. code called in main activity prepares set of audio instructions given test. there no errors within activity. second activity called, long string of errors on logcat. 03-07 13:23:43.820: i/actionlogger(21435): gentest_info_test #0 created. 03-07 13:23:43.830: i/actionlogger(21435): gente
Read more

python - ('The SQL contains 0 parameter markers, but 50 parameters were supplied', 'HY000') or TypeError: 'tuple' object is not callable -

-
import pyodbc,nltk,array cnxn = pyodbc.connect('driver={mysql odbc 5.1 driver};server=127.0.0.1;port=3306;database=information_schema;user=root; password=1234;option=3;') cursor = cnxn.cursor() cursor.execute("use collegedatabase ;") cursor.execute("select * sampledata ; ") cnxn.commit() s=[] j=[] x=[] words = [] w = [] sfq = [] pos=[] entry in cursor: s.append(entry.injury_type),j.append(entry.injury_desc) nltk.tokenize import punktwordtokenizer nltk.corpus import stopwords tokenizer = punktwordtokenizer() english_stops = set(stopwords.words('english')) in range(0,26): # filter stop words tokenizer.tokenize(j[i]) w.append([word word in tokenizer.tokenize(j[i]) if word not in english_stops]) in range(0 , 26):#converting tokenzied text ito string sfq.append(" ".join(w[a])) replacers import regexpreplacer replacer = regexpreplacer() in range (0,26):#pos tagging replacer.repl
Read more