The connection pool

Connection pooling allows client applications to reuse connections instead of creating a new one each time the HCL® OneDB® .NET Core Provider needs to connect to a database.

To make a connection available in the pool, you must close it after your application has finished using the connection. For reuse, a connection must currently be unused and must still be connected to the server.

You use the Pooling, Max Pool Size, Connection Life Time, and Min Pool Size connection string attributes to control the connection pool.

The Idle Timeout internal parameter is the standard protocol for removing connections from the pool and prevents connections from remaining active indefinitely in the server. Idle Timeout has a value of 120 seconds, which cannot be changed by setting a new value in the connection string. With Idle Timeout, when a connection is unused in the connection pool for more than 120 seconds, the connection is closed and removed from the pool.