stmtcache
Specify whether Uniface should enable or disable the Uniface cache mechanism for statements.
USYS$Mnemonic_PARAMS
= stmtcache : on | off
Values
off—Uniface statement cache is disabled.Note: This may reduce performance to some degree.
on—Uniface statement cache is enabled. Default.
Use
| Applies to | Mnemonic | Connector Syntax |
|---|---|---|
| Microsoft SQL connector | MSS | USYS$MSS_PARAMS |
| PostgreSQL connector | PGS | USYS$PGS_PARAMS |
stmtcache
The following example specifies that the DBMS is responsible for maintaining referential integrity, that the connector will not use stored procedures, and that Uniface statement cache is disabled:
USYS$MSS_PARAMS ri:dbms, procs:off, stmtcache:off
