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]