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.

Table 1. Summary: Connection Pooling Connection Options
Option Characteristic
Connection 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 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 An integer value to specify the amount of time, in seconds, to keep connections open in a connection pool.

Default: 0
Max Pool Size An integer value to specify the maximum number of connections within a single pool.

Default: 100
Min Pool Size 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