Thanks,

Do you mean 32-bit memusage by 2/3gb limit???

-TP-


_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Adam
Sent: 9. marraskuuta 2007 0:35
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: DefaultCachePages in FB1.5.x and 2.x



--- In firebird-support@ <mailto:firebird-support%40yahoogroups.com>
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







[Non-text portions of this message have been removed]