Reference
:
Designing ODBC Applications for Performance Optimization
:
Retrieving Data
Try DataDirect Drivers Now
Retrieving Data
To retrieve data efficiently, return only the data that you need, and choose the most efficient method of doing so. The guidelines in this section will help you optimize system performance when retrieving data with ODBC applications.
In this section:
Retrieving Long Data
Reducing the Size of Data Retrieved
Using Bound Columns
Using SQLExtendedFetch Instead of SQLFetch
Choosing the Right Data Type