We are currently working with web software that is going to market with great acceptance. It receives many partner interfaces and generates a lot of content for each table. In the past we chose to create a database for each client, and a centralizing database and user router, all in Mysql. But today I have CPU and Memory bottleneck on a good server, and we are hanging only 20 clients. My question is whether the model we adopted in the past is the best one, ie 1 BD for each client that comes in (more or less 50 MB daily growth) or if I hang everything in just one database. Windows Server, .net, BD Mysql
Thank you very much for the help.