Default Cache Size Per Server

Go Up to Configuring the Database Cache

For SuperServer installations, you can configure the default number of pages used for the database caches. By default, the database cache size is 2048 pages per database. You can modify this default by changing the value of DATABASE_CACHE_PAGES in the ibconfig configuration file. When you change this setting, it applies to every active database on the server.

You can also set the default cache size for each database using the gfix or SET PAGE CACHE utilities. This approach permits greater flexibility, and reduces the risk that memory is overused, or that database caches are too small.

We strongly recommend that you use gfix or SET PAGE CACHE to set cache size rather than DATABASE_CACHE_PAGES.