Designing ODBC Applications for Performance Optimization

Designing ODBC Applications for Performance Optimization
Developing performance-oriented ODBC applications is not easy. 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. This chapter contains some general guidelines that have been compiled by examining the ODBC implementations of numerous shipping ODBC applications. These guidelines include:
Following these general rules will help you solve some common ODBC performance problems, such as those listed in the following table.
Using Catalog Functions
Retrieving Data
Selecting ODBC Functions
Managing Connections and Updates

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.