Jump to content

Database architecture for large web based software application


jwwceo

Recommended Posts

Hello All! 

 

I am developing an app for a customer that is quite a bit more complex than anything I've made before. Basically, I am creating a cloud based software app that will have businesses paying a monthly fee to gain access. Each user will have their own set of data and the data set could get large as time goes by. 

 

My question is: Do most applications like this create a new database for each user, or do users share tables within the same database.

 

I can see advantages and disadvantages of each. I want the application to be fast, and be scalable so as users grow we can seamlessly add resources to keep the service snappy.

 

Best,

 

James

 

 

Link to comment
Share on other sites

Definitely start with one database. Only once you've built the application and have done some load testing will you know if the database is going to be a bottleneck or not. You do not want to set up each customer on separate databases. That would create a nightmare of managing any updates. But, if you do determine that the database will be a bottleneck, you would probably want to set it up so you can have multiple databases that each host many accounts.You would just need to implement a catalog/data abstraction layer that uses the account to determine which database to use. My company has an application used by hundreds of organizations world-wide and we've just started to implement such a solution.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.