Enables the connection pooling feature, which allows the provider to reuse existing connections instead of creating new ones for each request.

Data Type

bool

Default Value

false

Remarks

UseConnectionPooling reduces the overhead associated with frequent connection creation, improving performance in applications with high connection usage. When connection pooling is enabled, your application must explicitly close each connection once it is no longer needed. Closing a connection returns it to the pool so it can be reused, rather than physically terminating it. If a connection remains idle beyond the PoolIdleTimeout duration, the server closes it automatically to free resources.

Connection pooling is disabled by default, but you can still customize the behavior of the connection pool using additional properties, such as PoolMaxSize, PoolIdleTimeout, and PoolWaitTime. These properties enable fine-tuning of the pool size, idle connection timeout, and the wait time for a connection to become available.

For information on using connection pools, see Connection Pooling.