nosql.statementCacheSize property

Controls an internal statement cache that is associated with a connection. The data type of this property is int.

Description

Managing the internal statement cache can help to increase performance. Performance can be improved by reusing the SQL statement objects that are generated internally by most of the NOSQL APIs. For example, when an application calls a NOSQL API it generates a SQL statement that is sent to the Db2® database. Each SQL statement has an object that is associated with it that is prepared internally by the JDBC driver. These statement objects are cached and can be reused if the same NOSQL API is called multiple times by the application.

Values

nosql.caseSensitiveNames positive integer | 0 or negative integer

positive integer: Enables the internal statement cache for a connection, and specifies the number of statements that the IBM® Data Server Driver for JDBC and SQLJ keeps open in the cache.
0 or negative integer: Disables internal statement caching for the connection. 0 is the default.

The nosql.statementCacheSize property is used only when application obtains the DB object that use the following getDB() APIs that are defined under the com.ibm.nosql.json.api.NoSQLClient class:

```
 static DB getDB(String jdbcUrl) 
```

 static DBgetDB(String jdbcUrl, String schema)

 static DB getDB(String jdbcUrl, String user, String pass)

 static DB getDB(String jdbcUrl, String user, String pass, String schema)