You can configure attributes of a connection pool for optimal performance and scalability using the methods provided by the DataDirect Connection Pool Manager classes.

Some commonly set connection pool attributes include:

  • Minimum pool size, which is the minimum number of connections that will be kept in the pool for each user
  • Maximum pool size, which is the maximum number of connections in the pool for each user
  • Initial pool size, which is the number of connections created for each user when the connection pool is initialized
  • Maximum idle time, which is the amount of time a pooled connection remains idle before it is removed from the connection pool