Article: Performance Tuning Of A Daffodil DB / One$DB - JDBC Application

Performance Tuning Of A Daffodil DB / One$DB - JDBC Application

This article illustrates the best practices to improve the performance of Daffodil DB / One$DB JDBC Driver. This article focuses on how to improve the performance of a Daffodil DB / One$DB JDBC application using Statement, PreparedStatemnt, CallableStatement and ResultSet interfaces. Choosing the right statement interfaces and right methods according to your SQL query plays a vital role in improving the performance of a JDBC Driver.



JDBC Overview



JDBC API provides standard set of interfaces to work with databases like Daffodil DB / One$DB, Oracle, Derby etc. Connection interface encapsulates database connection functionality, Statement interface encapsulates SQL statement representation and execution functionality whereas ResultSet interface encapsulates retri...
 

View Article:
Performance Tuning Of A Daffodil DB / One$DB - JDBC Application

Back To Articles Directory Listing Page

Home | Back To Articles Directory

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.