Record Facts Cache (Additional Parameter)

Previous Next

See Also

The Record Facts Cache additional parameter is used to specify whether information on row events or record locks should be cached in memory, on file, or not at all. This information is used to optimize queries by solving more queries locally.

Allowed values are:

· In Memory (the default)


· On File


· Not Active


This parameter should be set to In Memory wherever possible. It should be set to On File if you experience problems with memory that cannot be solved by reducing the value of the Record Facts Cache Size parameter.