Databases Reference
In-Depth Information
CHAPTER SIX
JDBC Applications:
Developing performance-optimized JDBC applica-
tions 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 applica-
tions. 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 here resembles
those chapters. While there are some similarities, this chap-
ter focuses on specific information about coding for JDBC.
157
