derby.language.statementCacheSize

Function

Defines the size, in number of statements, of the database statement cache
(prepared statements kept in memory).

This property controls the number of precompiled statements which
Derby keeps in its statement
cache. Consider raising this number if statement preparation is taking too much
time.

For more information on the statement cache, see "Using the statement cache"
in Tuning Derby.

Set this property to zero if you find that deadlocks are occurring when
prepared statements become outdated. These deadlocks can happen in
multi-threaded applications that alternate selects and updates.

Default

100 statements.

Example

derby.language.statementCacheSize=200

Dynamic or static

This property is static; if you change it while
Derby is running, the change
does not take effect until you reboot.