thanks dmitry !
On 12/26/2011 1:54 AM, Dmitry Kuzmenko wrote: > > 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 > > [Non-text portions of this message have been removed]
