Thomas Steinmaurer wrote:

>> When you connect to the database and no connection is established yet,
>> FB server will allocate cache memory. The size of cache is determined that way:
>>
>> 1) if the database has specified cache size (e.g. using gfix), then that value is used. Period.
>> otherwise
>> 2) if you specified cache size during connection, that value is used,
>> otherwise
>> 3) DefaultDbCachePages is used.
>>
>>
>> When the application connects to the database using isc_attach_database() FB API call,
>> it can specify desired cache size by isc_dpb_num_buffers value. If you do not use FB API directly,
>> you have to consult documentation of your connect library or application.
>> E.g. with ISQL you can specify that value as command line parameter "-cache 12345",
>>
>
> Is this a temporary setting for the connection or will this be the page
> buffers value for further connections as well, e.g. queryable via the
> header page?
>

Temporary for this connection only.

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br