Hello, Vander! Sunday, December 25, 2011, 5:54:51 PM, you wrote:
VCS> yes, but what i want to know if for the "same amout of data", VCS> is their any disadvantage (or advantage) to use several database instead VCS> of one ? I don't see any need to keep 1000 client's data in one database, except you need to make queries over some or all clients data by one sql statement. So, if each client's data is separate from others, than it is no any advantage to keep them in one database. Also, in terms of failure or maintenance keeping several client's data in one database causes threats to grow. If you have 10k clients, I do not suggest to separate them all to 10k databases, because it was already spoken that it can cause problems with the filesystem. Anyway, splitting clients to different databases allow you to handle databases on different servers, so, you can scale your system performance (instead of trying to fix problems with 10k clients and 1 database for all of them). -- Dmitry Kuzmenko, www.ib-aid.com
