Subject Re[2]: [firebird-support] 1000 databases per server ?
Author Dmitry Kuzmenko
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