Subject Re: [firebird-support] Effect of DefaultDbCachePages?
Author Thomas Steinmaurer
> 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?


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/