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 SIX: JDBC Applications: Writing Good Code

Developing performance-optimized JDBC applications is not easy. Database drivers don’t throw exceptions to tell you when code is running slow. This chapter describes some general guidelines for coding practices that improve JDBC application performance. These guidelines have been compiled by examining the implementations of numerous shipping JDBC 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 5 and 7), you’ll notice that some of the information ...

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