Use manually declared indices (indexes)?
For manually declared indices (if used), use the unique constraint?
Maximum number of idle connections that should remain in the pool. Defaults to 50% of pool-maxsize and always greater than pool-minsize.
Sets the number of milliseconds between eviction runs for idle connections.
Sets the minimum amount of time a connection may sit idle in the pool before it is eligible for eviction.
Sets the maximum amount of time (in milliseconds) to wait for a connection when the pool is exhausted
This parameter is currently not implemented
This parameter is currently not implemented
This parameter is currently not implemented
Connection validation query
Run validation query when a connection is created in the pool
Run validation query when a connection is borrowed from pool
Run validation query when a connection is returned to pool
Run validation query while connection is in idle in the pool with frequency set in time-between-eviction-runs-millis
This parameter is currently not implemented