Subject Re: [ib-support] DB Cache
Author Helen Borrie
At 08:04 AM 05-12-01 -0800, you wrote:
>With FireBird RC1 how do you set the system wide database cache size?

Several alternatives:

1. Set it in the ibconfig/isc_config file

Server-wide default number of database pages per database to allocate in memory. The configured value can be overridden by clients.

2. Use gfix:

Syntax for setting cache size

gfix -b n db_name

where n is the number of database pages to be reserved.

3. Clients can set it through the API function isc_attach_database(), by specifying a value for the cache size member of the database parameter block (DPB). In Classic, a single connection can override any default size that is currently applicable for the database. In Superserver it will increase or decrease the cache size of the pooled cache.


All for Open and Open for All
InterBase Developer Initiative ยท