Subject Re: DefaultCachePages in FB1.5.x and 2.x
Author Adam
--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:
>
> TP:
>
> > Some versions had some restriction that I should not be grater than
> 10K,
> > is it gone in FB1.5x or FB2.X???
>
> With v2.0 the cache manager logic was reworked and original 10K pages
> limit was eliminated, the cache now scales in a near-linear mode
> (whereas v1.x the cache scaled inversely).
>
> Accordingly, you can set the size to as large as you want.

But keep in mind memory use if you are using a 32 bit version of
Superserver. Also keep in mind that when using classic server these
settings are per connection. It is a very bad thing to have such a
large cache that the OS pages part of it back to disk.

Adam