skip to main content
Designing JDBC Applications for Performance Optimization
  
Designing JDBC Applications for Performance Optimization
Developing performance-oriented JDBC applications is not easy. JDBC drivers do not throw exceptions to tell you when your code is running too slow. This section presents some general guidelines for improving JDBC application performance that have been compiled by examining the JDBC implementations of numerous shipping JDBC applications. These guidelines include:
*Use DatabaseMetaData methods appropriately
*Return only required data
*Select functions that optimize performance
*Manage connections and updates
Following these general guidelines can help you solve some common JDBC system performance problems, such as those listed in the following table.
Problem
Solution
See guidelines in…
Network communication is slow.
Reduce network traffic.
Evaluation of complex SQL queries on the database server is slow and can reduce concurrency.
Simplify queries.
Excessive calls from the application to the driver slow performance.
Optimize application-to-driver interaction.
Disk I/O is slow.
Limit disk I/O.
In addition, most JDBC drivers provide options that improve performance, often with a trade-off in functionality. If your application is not affected by functionality that is modified by setting a particular option, significant performance improvements can be realized.
* Using Database Metadata Methods
* Returning Data
* Selecting JDBC Objects and Methods
* Managing Connections and Updates