Values are in seconds, and a value of 0 indicates the maximum connection timeout.ĭetermines whether the database connection is reset when being drawn from the pool.
When a connection is returned to the pool, if its creation time was longer than x seconds ago, with x being the value of this property, then the connection is destroyed. Table 5-7 Connection Pooling Connection String Keywords For example, the OLE DB provider controls connection pooling (also known as resource or session pooling) based on the value set for the OLE DB Services keyword in the connection string. Not all keywords are available for every provider. Table 5-7 provides a list of connection string keywords that you can use to control how a specific connection interacts with the connection pool. For example, to specifically disable connection pooling, you set Pooling=False in your connection string. You can control connection pooling behavior (or disable pooling altogether) by setting connection string keywords specific to connection pooling.
When you create ADO.NET connection objects, connection pooling is enabled by default. For connection strings that use Integrated Security, a separate pool is created for each unique identity. Connection pooling provides a much higher level of performance by eliminating the need for the database to constantly create and dispose of connections.Ĭonnection pools are separated by process, application domain, and connection string. Typical applications use the same connection objects to continuously fetch and update data from a database. In other words, opening and closing connections that use the same connection string and credentials can reuse a connection that is available in the pool. Configure a connection for connection pooling by configuring connection string values.Įstimated lesson time: 30 minutes What Is Connection Pooling?Ĭonnection pooling allows you to reuse existing connections so you don’t have to continuously create and dispose of connections that have the same configuration.
0 kommentar(er)
