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

This property 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 connector closes it automatically to free resources.

By default, connection pooling is disabled. Additional properties, such as PoolMaxSize, PoolIdleTimeout, and PoolWaitTime, allow you to customize the behavior of the connection pool. These settings allow fine-tuning of the pool size, idle connection timeout, and the wait time for a connection to become available. Review Connection Pooling for information on using connection pools.