Click here to Skip to main content
15,907,392 members
Home / Discussions / Database
   

Database

 
GeneralRe: datetime problem Pin
Member 1026351925-Feb-14 21:39
Member 1026351925-Feb-14 21:39 
AnswerRe: datetime problem Pin
Kornfeld Eliyahu Peter25-Feb-14 21:44
professionalKornfeld Eliyahu Peter25-Feb-14 21:44 
GeneralRe: datetime problem Pin
Bernhard Hiller25-Feb-14 21:46
Bernhard Hiller25-Feb-14 21:46 
AnswerRe: datetime problem Pin
jschell26-Feb-14 9:26
jschell26-Feb-14 9:26 
AnswerRe: datetime problem Pin
GuyThiebaut26-Feb-14 21:49
professionalGuyThiebaut26-Feb-14 21:49 
QuestionHow to use temporary tables in SQL Server 2008? Pin
Rakesh Meel24-Feb-14 1:58
professionalRakesh Meel24-Feb-14 1:58 
AnswerRe: How to use temporary tables in SQL Server 2008? Pin
David Mujica24-Feb-14 3:18
David Mujica24-Feb-14 3:18 
QuestionHelp required on Database Model Pin
Nitheesh George23-Feb-14 6:05
Nitheesh George23-Feb-14 6:05 
Hi Everybody,

Please note that I am not a very senior developer so want help from you guys...

We are going to start a new project which is very similar to Shopify. The proposed solution will include the following,

1. A admin site which manages Merchants. Here the merchants will have multiple stores under him.

2. A Tablet client which downloads/updates the data from/to the website using web services.

My questions is,

1. So while designing the database model whether is it a good idea to keep separate databases for each merchant or keep a single database?.

2. How much data can be kept in a single table?.

3. Regarding the scalability and maintainability which is the proper design, single database or multiple database?

4. Is there a bottle neck in MS SQL server when creating multiple databases instead of one?.

5. Which kind of sever solution in this case we need to propose, Cloud based database or Godaddy like hosting server?. Can a godaddy like hosting service provide a performance like Amazon.

Please note that we are planning to use MS SQL server for keeping the data.

Thanks & Regards,

Nitheesh George
Nitheesh George

http://www.simpletools.co.in

AnswerRe: Help required on Database Model Pin
Mycroft Holmes23-Feb-14 11:52
professionalMycroft Holmes23-Feb-14 11:52 
AnswerRe: Help required on Database Model Pin
Eddy Vluggen24-Feb-14 8:17
professionalEddy Vluggen24-Feb-14 8:17 
AnswerRe: Help required on Database Model Pin
Duncan Edwards Jones26-Feb-14 11:06
professionalDuncan Edwards Jones26-Feb-14 11:06 
Questionintricate date query sql Pin
Martin Niemandt19-Feb-14 22:07
Martin Niemandt19-Feb-14 22:07 
AnswerRe: intricate date query sql Pin
Richard MacCutchan19-Feb-14 22:19
mveRichard MacCutchan19-Feb-14 22:19 
GeneralRe: intricate date query sql Pin
Martin Niemandt19-Feb-14 22:28
Martin Niemandt19-Feb-14 22:28 
GeneralRe: intricate date query sql Pin
Richard MacCutchan19-Feb-14 23:08
mveRichard MacCutchan19-Feb-14 23:08 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 0:11
Martin Niemandt20-Feb-14 0:11 
GeneralRe: intricate date query sql Pin
Richard MacCutchan20-Feb-14 0:16
mveRichard MacCutchan20-Feb-14 0:16 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 0:24
Martin Niemandt20-Feb-14 0:24 
GeneralRe: intricate date query sql Pin
Richard MacCutchan20-Feb-14 0:29
mveRichard MacCutchan20-Feb-14 0:29 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 0:41
Martin Niemandt20-Feb-14 0:41 
AnswerRe: intricate date query sql Pin
Mycroft Holmes20-Feb-14 12:01
professionalMycroft Holmes20-Feb-14 12:01 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 18:53
Martin Niemandt20-Feb-14 18:53 
GeneralRe: intricate date query sql Pin
Mycroft Holmes20-Feb-14 19:46
professionalMycroft Holmes20-Feb-14 19:46 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 20:45
Martin Niemandt20-Feb-14 20:45 
GeneralRe: intricate date query sql Pin
Mycroft Holmes20-Feb-14 21:36
professionalMycroft Holmes20-Feb-14 21:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.