Designing JDBC Applications for Performance Optimization


Developing performance-oriented JDBC applications is not easy. JDBC drivers do not throw exceptions to say that your code is running too slow.

These guidelines were compiled by examining the JDBC implementations of numerous shipping JDBC applications. The guidelines discuss using database metadata materials, retrieving data, selecting JDBC objects and methods, designing JDBC applications, and updating data.

The following table summarizes some common JDBC system performance problems and suggests some possible solutions.

Problem
Solution
See guidelines in...
Network communication is slow
Reduce network traffic
Evaluation of complex SQL queries on the database server is slow and might reduce concurrency
Simplify queries
Excessive calls from the application to the driver decrease performance
Optimize application-to-driver interaction
Disk input/output is slow
Limit disk input/output


Previous Document Previous Page Next Document Next Page Synchronize TOC Synchronize with Contents