Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Additional Features to Enhance DataServer Performance : Connection pooling : Main components : Considerations when using ODBC connection pooling and DataServer connection management
 
Considerations when using ODBC connection pooling and DataServer connection management
When both ODBC connection pooling and DataServer connection management are enabled, set the number of managed connections to a value that covers the required number of connections for a typical application. Reuse of the managed connections takes precedence over ODBC connection pool connections. The ODBC connection pool is then an overflow handler for connections required beyond the capacity of the managed connections. This configuration ensures that there is little risk of having a negative impact on performance by downgrading to a Fast Forward-Only server-side cursor in the mainline transaction-oriented connection. For more information on monitoring the performance of your connection pool, see Monitoring cursor and connection use.