A technique for optimizing Active Server Pages (ASP) applications running on Internet Information Server (IIS) version 4. Connection pooling allows more efficient implementation when connecting ASP front-end applications to a back-end database.
Connection pooling involves the pooling of open database connectivity (ODBC) connections to reduce the frequency at which ODBC connections need to be opened and closed on heavily accessed servers. Connection pooling improves ASP performance for ODBC-enabled Web applications and provides a graceful way to manage connection timeouts.
To use ODBC connection pooling on IIS, perform the following steps:
Once connection pooling is enabled, the ODBC driver will check the connection pool for idle connections it can reuse before creating a new connection in response to an ODBC request. When connections are released, they are returned to the connection pool instead of being closed.
You can control the amount of time an idle connection remains in the pool using the CPTimeout registry setting, which by default is set to 60 seconds.