Designing JDBC applications for performance optimization
:
Selecting JDBC objects and methods
Try DataDirect Drivers Now
Selecting JDBC objects and methods
The guidelines in this section will help you to select which JDBC objects and methods will give you the best performance.
In this section:
Using parameter markers as arguments to stored procedures
Using the statement object instead of the PreparedStatement object
Using batches instead of prepared statements
Choosing the right cursor
Using get methods effectively
Retrieving auto-generated keys