Connection Pooling

Connection Pooling is a technique for optimizing Active Server Pages applications running on Internet Information Server (IIS).

What is Connection Pooling?

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.

How It Works: Connection Pooling

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:

  1. Configure the database driver using ODBC in Control Panel.
  2. Enable connection pooling in the Microsoft Windows NT registry.
  3. Open individual connections in your Microsoft ActiveX Data Objects (ADO) code right before data access is needed for an ASP page, and release connections as soon as the data has been accessed.

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.

TIP

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.