wood burning stoves 2.0*
The moose likes JDBC and the fly likes JDBC 2.0 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC 2.0" Watch "JDBC 2.0" New topic
Author

JDBC 2.0

Rajeev Iyer
Ranch Hand

Joined: Jun 19, 2002
Posts: 42
Hi...
though the JDBC 2.0 has many more methods for convinience, is it slower than the previous version?
Thanks...
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
What do you mean by "is it slower"? This will depend on exactly what statements you are executing, your database driver, etc.


Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Originally posted by Rajeev Iyer:
Hi...
though the JDBC 2.0 has many more methods for convinience, is it slower than the previous version?
Thanks...
Remember, the jdbc 2.0 is only a specification, so there is no code written. The performance relies solely on the underlying implementation of the driver you are using. But in general, a scrollable resultset is slower than a non scrollable, and the more "convenience" stuff you use, the more chance that you are introducing more overhead ( slower code ). Using jdbc 1.0 methods on a jdbc 2.0 compliant driver should in theory run the same.
Jamie
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC 2.0
 
Similar Threads
Problem with BATCH UPDATES
methods deprecated?
ResultSet Fnction
Difference between JDBCs
scrollable resultset