The Application Server uses JDBC to store and retrieve HADB data. For best performance, configure the JDBC connection pool for the fastest possible HADB read/write operations.
Configure the JDBC connection pool in the Admin Console under Resources > JDBC > Connection Pools > pool-name. The connection pool configuration settings are:
Initial and Minimum Pool Size: Minimum and initial number of connections maintained in the pool (default is 8)
Maximum Pool Size: Maximum number of connections that can be created to satisfy client requests (default is 32)
Pool Resize Quantity: Number of connections to be removed when idle timeout timer expires
Idle Timeout: Maximum time (seconds) that a connection can remain idle in the pool. (default is 300)
Max Wait Time: Amount of time (milliseconds) caller waits before connection timeout is sent
For optimal performance, use a pool with eight to 16 connections per node. For example, if you have four nodes configured, then the steady-pool size must be set to 32 and the maximum pool size must be 64. Adjust the Idle Timeout and Pool Resize Quantity values based on monitoring statistics.
For the best performance, use the following settings:
Connection Validation: Required
Validation Method: metadata
Transaction Isolation Level: repeatable-read
In addition to the standard attributes, add the two following properties:
cacheDatabaseMetaData: false
eliminateRedundantEndTransaction: true
To add a property, click the Add Property button, then specify the property name and value, and click Save.
For more information on configuring the JDBC connection pool, see Tuning JDBC Connection Pools.