Connection pooling means that connections are reused rather than created each time a connection is requested. Your application can pool connections using DataDirect connection pooling.
Connection pooling is performed in the background and does not affect how an application is coded. Connection pooling works only with connections that are established using SQLConnect or SQLDriverConnect with the SQL_DRIVER_NO_PROMPT argument and only with applications that are thread-enabled.
DataDirect connection pooling that is implemented by the ODBC Client is different than connection pooling implemented by the Windows Driver Manager. The Windows Driver Manager opens connections dynamically, up to the limits of memory and server resources. DataDirect connection pooling, however, allows you to control the number of connections in a pool through the Min Pool Size (minimum number of connections in a pool) and Max Pool Size (maximum number of connections in a pool) connection options. In addition, DataDirect connection pooling is cross-platform, allowing it to operate on UNIX and Linux.
Important: On a Windows system, do not use both Windows Driver Manager connection pooling and DataDirect connection pooling at the same time.
