skip to main content
Using the Driver : Using DataDirect Connection Pooling : Configuring Connection Pooling
  

Try DataDirect Drivers Now

Configuring Connection Pooling

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 9. Summary: Connection Pooling Connection Options
Option
Characteristic
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)
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)
An integer value to specify the amount of time, in seconds, to keep connections open in a connection pool.
Default: 0
An integer value to specify the maximum number of connections within a single pool.
Default: 100
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