Subject | Re: [firebird-support] Effect of DefaultDbCachePages? |
---|---|
Author | Thomas Steinmaurer |
Post date | 2009-01-21T14:08:42Z |
> When you connect to the database and no connection is established yet,Is this a temporary setting for the connection or will this be the page
> 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",
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/