Subject Re: [firebird-support] DefaultDBCache VS Page Buffers
Author Anderson Farias
Hi,

> I have a question regarding firebird cache settings. In the conf file
> there is an entry called DefaultDBCache which allows to set the cache size
> for firebird database. I also see that this setting can also be set per
> database by the setting page buffer using gfix command, like
>
> gfix -b[uffers] BUFFERS database_name
>
> Are they same?

YES


> Is the DefaultDBCache setting is on a server level and page buffer setting
> is on a database level??

If no setting is defined for the database (eg. gfix -buffers 0 db) than FB
uses the setting on firebird.conf, otherwise, db setting is used.


> I am running FB 2.1 Superserver and am wondering how these settings will
> effect me.
> Will appreciate any response.

Set a global number of pages to be used for cache of *any* database on your
server at firebird.conf. When needed, set a especific number to some db

(or if you prefer, always set especific for each db on your server)



Regards,
Anderson Farias