MaxFileSystemCache

V.Khorsun

(V.2.1) Sets a threshold determining whether Firebird will
allow the page cache to be duplicated to the filesystem cache or not. If this parameter is set to
any (integer) value greater than zero, its effect depends on the current default size of the page cache:
if the default page cache (in pages) is less than the value of MaxFileSystemCache (in pages) then filesystem
caching is enabled, otherwise it is disabled.

Note

This applies both when the page cache buffer size is set implicitly by the
DefaultDBCachePages setting or explicitly as a database header attribute.

Thus,

To disable filesystem caching always, set MaxFileSystemCache to zero

To enable filesystem caching always, set MaxFileSystemCache an integer value that is
sufficiently large to exceed the size of the database page cache. Remember that the effect of
this value will be affected by subsequent changes to the page cache size.

Important

The default setting for MaxFileSystemCache is 65536 pages, i.e. filesystem caching is
enabled.