ConnectionPool (CPOOL) connection parameter

ConnectionPool={ NO | YES [ ( [ Timeout=timeout-sec; ] [ MaxCached=max-cached-conn ] ) ] }

All platforms except Windows Mobile and non-threaded Unix clients.

timeout-sec The idle timeout period, in seconds, of the connection pool. The default value is 60 seconds. Cached connections that are not reused within the time specified by the timeout-sec value are disconnected and are no longer available for reuse.
max-cached-conn The maximum number of cached connections from each application. The default value is five connections. A connection is cached if it is disconnected and the maximum number of connections specified by the max-cached-conn value has not been reached. The connection is reinitialized, and the cached connection remains connected to the database server even though the application has disconnected it. For information about cleanup and reinitialization tasks that are performed, see Connection pooling.

YES

Connection pooling may improve the performance of applications that make multiple, brief connections to the database server. When a connection is disconnected it is automatically cached and may be reused when the application reconnects. For a connection to be pooled, the connection name can be different, but all other connection parameters must be identical.

The following connection string fragment turns connection pooling off.

ConnectionPool=NO;

The following connection string fragment turns connection pooling on with a maximum of 10 cached connections.

CPOOL=YES(MaxCached=10);

ConnectionPool (CPOOL) connection parameter

Syntax

Usage

Allowed values

Default

Remarks

See also

Example