Developing performance-optimized ODBC applications is not easy. Microsoft’s ODBC Programmer’s Reference does not provide information about performance. In addition, ODBC drivers and the ODBC Driver Manager don’t return warnings when applications run inefficiently. This chapter describes some general guidelines for coding practices that improve ODBC application performance. These guidelines have been compiled by examining the ODBC implementations of numerous shipping ODBC applications. In general, the guidelines described in this chapter improve performance because they accomplish one or more of the following goals:
• Reduce network traffic
• Limit disk I/O
• Optimize application-to-driver interaction ...