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