Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

SETENV DH_DYN_CACHED_STATEMENTS

Number of prepared statements to cache.

FairCom DB SQL statement caches provide a performance benefit by allowing the SQL engine to reuse previously parsed and optimized statements. Proper sizing of this cache can offer significant performance improvements to applications. Two independent caches are used, a static statement cache and a dynamic statement cache. FairCom DB SQL supports setting the size of these statement caches (the number of entries that can be stored) up to 16000.

Default: On Windows the default size is 150; on Unix systems the default size is 250.

See Also

TOCIndex