Developing performance-oriented ODBC applications is not an easy task. You must be willing to change your application and test it to see if your changes helped performance. Microsoft’s ODBC Programmer’s Reference does not provide information about system performance. In addition, ODBC drivers and the ODBC Driver Manager do not return warnings when applications run inefficiently.
Some general guidelines for developing performance-oriented ODBC applications include:
Use catalog functions appropriately.
Retrieve only required data.
Select functions that optimize performance.
Manage connections and updates.
See "Designing ODBC Applications for Performance Optimization" for complete information.
Use catalog functions appropriately.