Subject Re: [firebird-support] Page buffers and DefaultDbCachePages
Author Alexandre Benson Smith
k_smith_000 wrote:

>Recently I've found 'page buffers' parameter which can be read by
>issuing command 'gstat -h'.
>I also know serwer wide parameter - DefaultDbCache.
>My question is what's the difference between DefaultDbCache and page
>buffers parameters?
>If I have:
>Page size = 4096
>Page buffers = 1000
>DefaultDbCache = 2048
>Connected users = 20
>Will the cache size for each user eqal 4096*2048*20?
>I'm using Firebird 1.5.2 CS.
>Thanks in advance!
>Kevin Smith

The parameter in the config file works if the database has page buffers
=0 (in other words "use the default").

If defined in the database it overrides the config default option.

Since you use CS, each user has it's own cache, and since your database
has a page buffers defined as 1000 each user has a cache of 1000 * 4096
all users will be 1000 * 4096 * 20.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil