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.

Dynamic or static

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