Min Pool Size
- Last Updated: May 24, 2022
- 1 minute read
- DataDirect Connectors
- ODBC
- SAP Sybase IQ 8.0
- Documentation
Attribute
MinPoolSize (MNPS)
Purpose
The minimum number of connections that are opened and placed in a connection pool, in addition to the active connection, when the pool is created. The connection pool retains this number of connections, even when some connections exceed their Load Balance Timeout value.
Valid Values
0 | x
Behavior
If set to 0, no connections are opened in addition to the
current existing connection.
If set to x, the start-up number of
connections in the pool is 5 in addition to the current existing
connection.
Notes
- This connection option can affect performance.
Example
If set to 5, the start-up number of connections in the
pool is 5 in addition to the current existing connection.
Default
0