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