The number of prepared SQL statements OpenESQL can cache such that the statements never again require preparation during a program run, thus improving performance.
Syntax:
STMTCACHE=n
NOSTMTCACHE
Parameter:
| n
|
Any number; however we recommend that you set this to a number between 20 and 300
|
Scope:
| Used at compile time:
|
No
|
| Behavior at run time:
|
Process
|
See
Scope - OpenESQL SQL Compiler Directive Options for more information.
Comments:
Exercise caution with this directive as STMTCACHE is a trade off between performance and memory use.
