Cloudscape Properties
Page 24 of 47

cloudscape.language.statementCacheSize

Function

Specifies the number of statements to cache per connection, which is useful if a connection recompiles exactly the same statement more than once. During caching, a connection attempts to reuse compiled statements rather than compile every statement anew. If Cloudscape finds an exact match for the statement, it does not have to recompile the statement.

Cached statements are aged out when the cache size is exceeded. Setting this property to zero disables caching.

Statement caching performs exact matches against incoming statements in the current connection. Statements that are not compilable are still cached.

NOTE: In situations in which you compile a prepared statement once and execute it many times, this property does not help performance. This property helps performance only in situations in which an application compiles exactly the same statement more than once (either executing the same Statement more than once, or preparing the same PreparedStatement more than once).

Default

20 statements.

Minimum Value

0.

Example

-- system-wide property
cloudscape.language.statementCacheSize=100

-- database-wide property
CALL PropertyInfo.setDatabaseProperty(
    'cloudscape.language.statementCacheSize',
    '100')

-- publishing a database-wide property
CREATE PUBLICATION APub
ADD TARGET DATABASE PROPERTY
cloudscape.language.statementCacheSize=
    '100'

Scope

system-wide

database-wide (publishable)

Dynamic or Static

This property is static; you must reboot for changes to take effect. For information about dynamic changes to properties, see Dynamic or Static Changes to Properties.