O'Reilly logo

The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability by Robert A. Steward, John Goodson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER FIVE: ODBC Applications: Writing Good Code

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required