Connection Level Optimizations

Establishing a connection to a database is an expensive process. Optimally, an application should perform as many tasks as possible while a connection is open. This can by achieved by:

• Pooling connections when using Windows Driver Manager
• Using multiple statement handles on the same connection handle

Also, you can fine tune application performance by setting the following connection level attributes:

• AutoCommit optimization
• Message transfer optimization (OPTMSG)
• Open-Fetch-Close optimization (OPTOFC)

For more information on connection level attributes, see Configuring Data Sources.