Setting Cache Size in Applications

From InterBase
Jump to: navigation, search

InterBase API: use the isc_dpb_num_buffers parameter to set cache size in a database parameter buffer (DPB).

IBX: use the num_buffers parameter to set cache size in the TIBDatabase parameter list. For example: num_buffers=250. For the parameter to be parsed correctly, there must be no spaces around the = sign.

The number of buffers passed by the InterBase API or IBX is trimmed to the database-specific cache setting if it is greater than that value.