Connection level optimizations

Establishing a connection to a database is an expensive process. Optimally, an application performs as many tasks as possible while a connection is open.

This process 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)