Subject RE: [firebird-support] Re: Firebird's scalability
Author Leyne, Sean
Dimitry,

> >The question is whether if the database becomes very large, will
using
> >500 databases instead of one improve performance? Does the size of
the
> >database have any substantial effect on performance?
>
> I'm afraid that using 500 databases with one FB server is
> impossible. They won't have enough RAM for page cache.

Although using a superserver for that many database would not be my
choice, your statement about not enough RAM is incorrect.

Using a cache setting of 1024 pages and a page size of 4KB, each
database would need 4MB of cache. Accordingly, 500 databases would need
only 2GB of RAM.

This is not an exceptional amount of memory.


Sean