Hi All

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.

Thanks,
Mike

__________________
Regards
Mike

Hi Mike,

which database are you talking about ? Sql server (CE 4)? MySQL ? ...


In general I think you will face performance issues (or let's say you will need to seriously look at the indexes you define to prevent them) as soon as you run into millions of records and need to join this with two other medium sized tables. If you then start making snapshot tables to speed up you queries, you still end up with high maintenance.


But frankly I don't dare to give more advise as there are many more factors involved and I for instance don't understand why you would also have 100 websites..