• Post Reply Bookmark Topic Watch Topic
  • New Topic

JDBC 2.0  RSS feed

 
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi...
though the JDBC 2.0 has many more methods for convinience, is it slower than the previous version?
Thanks...
 
Ranch Hand
Posts: 1512
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do you mean by "is it slower"? This will depend on exactly what statements you are executing, your database driver, etc.
 
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!