preparedStatementCacheSize

The preparedStatementCacheSize build descriptor option specifies how many prepared statements to keep in the runtime cache when the cachePreparedStatements build descriptor option is set to YES. The value is an integer greater than zero, and the default is 100.

When the cache is full and your code needs to use a prepared statement that is not in the cache, the least recently used prepared statement is removed from the cache and the new one is added.

The preparedStatementCacheSize option applies only to Java generation. If you generate Java runtime properties, the value you specify is assigned to the vgj.jdbc.pstmt.cache.size property.


Feedback