You may need to learn how to use the API and customize the DPB (database
parameter block) when connecting to a database. There is an event called
OnCustomizeDPB that you can use to add commands to this string of bytes that
give the server specific instructions upon connection. See the API
reference manual for instructions on how to add DPB items.

Jason Wharton

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Eyal
> Sent: Tuesday, April 26, 2005 6:06 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] How to specify cache (buffer) size
>
>
>
>
> Hi,
>
> I need to control the size of Firebird's page cache when connecting to
> a database. However I can't find any TIB_Connection property for that
> purpose.
>
> My application attaches to a central "controller" DB which is rather
> small and static, and to one of many "data" DBs. A data DB may be
> anything from a few thousands rows to millions of rows (company's
> financial data).
>
> Firebird allocates a seperate page cache for each database. There may
> be several clients accessing different DBs, so Firebird needs to
> allocate multiple caches. This can lead to a significant memory
> requirement.
>
> I read in http://www.cvalde.net/document/cache_settings_priority.htm
> that the cache size can be set at connection time. So I want to
> calculate a reasonable cache size before connecting to a data DB,
> based on the size of the DB. I have all the logic in place only I
> can't find the way to do it with IBO.
>
> Thanks,
>
> Eyal.