Databases Reference
In-Depth Information
CHAPTER FIVE
Writing Good Code
Developing performance-optimized ODBC applica-
tions is not easy. Microsoft's
ODBC Programmer's
Reference
does not provide information about perfor-
mance. In addition, ODBC drivers and the ODBC Driver
Manager don't return warnings when applications run
inefficiently. This chapter describes some general guide-
lines 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
•
Simplify queries
If you've read the other coding chapters (Chapters 6 and
7), you'll notice that some of the information here resembles
those chapters. While there are some similarities, this chap-
ter focuses on specific information about coding for ODBC.
123
