Micro Focus Visual COBOL 2.3 Update 1 for Eclipse (UNIX) > Programming > Data Access > Database Access > Reference > OpenESQL > SQL Compiler Directive Options > STMTCACHE

STMTCACHE

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

Parameter:

`n`	Any number; however we recommend that you set this to a number between 20 and 300

Properties:

Default:

STMTCACHE=20

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.