skip to main content
Reference : 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.
Note: The section describes functionality across a spectrum of data stores. In some cases, the functionality described may not apply to the driver or data store you are using. In addition, examples are drawn from a variety of drivers and data stores.
In this section: 
* Using Database Metadata Methods
* Returning Data
* Selecting JDBC Objects and Methods
* Managing Connections and Updates