| Subject | Re: [ib-support] DB Cache |
|---|---|
| Author | Helen Borrie |
| Post date | 2001-12-05T16:27:53Z |
At 08:04 AM 05-12-01 -0800, you wrote:
1. Set it in the ibconfig/isc_config file
database_cache_pages
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.
H.
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
>With FireBird RC1 how do you set the system wide database cache size?Several alternatives:
1. Set it in the ibconfig/isc_config file
database_cache_pages
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.
H.
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________