Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
HCL OneDB™ ODBC Driver GuideThe HCL OneDB™ ODBC Driver Programmer's Manual serves as a user guide and reference for HCL OneDB™ ODBC Driver, which is the HCL OneDB™ implementation of the Microsoft™ Open Database Connectivity (ODBC) interface, Version 3.0.
Improve application performanceThese topics suggest ways to improve performance of HCL OneDB™ ODBC Driver applications.
Connection level optimizationsEstablishing a connection to a database is an expensive process. Optimally, an application performs as many tasks as possible while a connection is open.

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)