MaxPooledStatements Parameter

The MaxPooledStatements parameter is automatically defined and set with a default value for all types of Database Endpoints.

Attention: Changing the default setting of the MaxPooledStatements parameter can cause reduced performance.

The MaxPooledStatements parameter specifies the maximum number of prepared statements that are cached by the Database Endpoint. When the value of MaxPooledStatements parameter is greater than zero, the Database Endpoint creates a prepared statement pool  to store PreparedStatement objects for later reuse. The performance cost of creating new PreparedStatement objects can be expensive, so storing and reusing existing PreparedStatement objects from a pool can result in a performance gain.




Feedback | Notices


Timestamp icon Last updated: Wednesday, 15 June 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/MaxPooledStatements_Parameter.html