derby.storage.pageCacheSize The derby.storage.pageCacheSize property defines the size, in number of pages, of the data page cache in the database (data pages kept in memory). derby.storage.pageCacheSize property Page cache sizeconfiguring

The actual amount of memory the page cache will use depends on the following:

  • The size of the cache, configured with the derby.storage.pageCacheSize property.
  • The size of the pages, configured with the derby.storage.pageSize property. automatically tunes for the database page size. If you have long columns, the default page size for the table is set to 32768 bytes. Otherwise, the default is 4096 bytes.
  • Overhead, which varies with JVMs.

When increasing the size of the page cache, you typically have to allow more memory for the Java heap when starting the embedding application (taking into consideration, of course, the memory needs of the embedding application as well). For example, using the default page size of 4K, a page cache size of 2000 pages will require at least 8 MB of memory (and probably more, given the overhead).

The minimum value is 40 pages. If you specify a lower value, uses the default value.

Default

1000 pages.

Example derby.storage.pageCacheSize=160
Dynamic or static

This property is static; if you change it while is running, the change does not take effect until you reboot.