connection pooling
Determines whether connection pooling is enabled.
USYS$Mnemonic_PARAMS =
connection pooling =
on
| off
USYS$Mnemonic_PARAMS =
cp =
on
| off
Use
Applies to |
Mnemonic |
Connector Syntax |
---|---|---|
MS SQL connector |
MSS |
USYS$MSS_PARAMS |
PostgreSQL |
PGS |
USYS$PGS_PARAMS |
Description
Connection pooling reduces the number of times that new connections must be opened by maintaining a pool of active connections, which can be reused. Instead of opening a new connection for each Open request, an available connection from the pool is used. When the application issues a Close request, the connection is returned to the pool for reuse by the next Open request.
MSS
By default connection pooling is enabled for the
MSS connector, but there can be circumstances when this is not desirable. For example, when the MSS
procedure sp_setapplrole
is used, logon fails with a Microsoft 08001 error.