Performance and Maintainability issue - Urgent
We are developing a software which will be distributed on web for different clients. Now we are facing some doubts regarding deployment.
In short, in our database we have a table where records will be updated and inserted daily by our client, say 50 records per day. So in total 1500 rows per month month for 1 client. Now if we have 100 clients, this will mean that 1,50,000 will be inserted per month, which will take the figures to million per year. This way database will become huge. More importantly we dont have huge servers or huge money to spend to get large servers. We are small start up company.
So what we are thinking is to deploy separate database and website for each client. But in terms of maintainence, it would be difficult as we will then have 100 websites and 100 databases for 100 clients.
Anyone can share their experience.