Buffer Pool Size

Restriction: This topic applies to Windows environments only.

You can set a buffer pool size to allocate the total amount of memory, in kilobytes, available for caching table, index, and dictionary files. A buffer pool size can range from 16K to 131,072K. The value of BP(0) sets the buffer pool size for data, and the value of BP(1) sets the buffer pool size for indexes. However, if you set BP(0) to a value of zero, this sets the buffer pool size to zero for both data and indexes.

Micro Focus's buffer management system is designed to enhance performance. Memory is allocated by the cache manager at XDB Server start up and then released at XDB Server shut down.

Note: Do not set cache to a number greater than the total amount of physical memory (RAM) available on a machine. Doing so can degrade performance due to operating system swapping. When determining how much cache to allocate, be sure to consider all types of caching, including Caching Options, Sort Space Size, and operating system cache.

To set the cache size for UNIX environments, or Windows when in blue screen mode:

  1. Press F6 Caching Options.
  2. Press F1 BP(0) Cache Size or F1 BP(1) Cache Size.
  3. Enter the appropriate cache size in KB and press Enter.
To set the cache size from the Windows XDB Server Configuration Utility service (Windows):
  1. Click the Cache tab.
  2. Type a cache size into each of the appropriate fields, or drag the slider to select a value for each.
Parent topic: Server Configuration Parameters