Summary of pooling-related options
- Last Updated: October 30, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Microsoft SQL Server 8.0
- Documentation
The following table summarizes how connection pooling-related connection options work with the drivers. See "Connection option descriptions" for additional details about configuring the options.
| Option | Characteristic |
|---|---|
| Connection Pooling (Pooling) | Specifies whether to use the driver’s connection
pooling. If set to 1 (Enabled), the driver uses connection pooling. If set to 0 (Disabled), the driver does not use connection pooling. Default: 0 (Disabled) |
| Connection Reset (ConnectionReset) | Determines whether the state of connections that are
removed from the connection pool for reuse by the application is reset to the initial
configuration of the connection.If set to 1
(Enabled), the state of connections removed from the connection pool for reuse by an
application is reset to the initial configuration of the connection. Resetting the
state can negatively impact performance because additional commands must be sent over
the network to the server to reset the state of the connection. If 0 (Disabled), the state of connections is not reset. Default: 0 (Disabled) |
| Load Balance Timeout (LoadBalanceTimeout) | An integer value to specify the amount of time, in
seconds, to keep connections open in a connection pool. If set to 0, inactive connections are kept open. If set to x, inactive connections are closed after the specified number of seconds passes. Default: 0 |
| Max Pool Size (MaxPoolSize) | An integer value to specify the maximum number of
connections within a single pool. Default: 100 |
| Min Pool Size (MinPoolSize) | An integer value to specify the minimum number of
connections that are opened and placed in a connection pool when it is created. If set
to 0, no connections are opened in addition to
the current existing connection. Default: 0 |