Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

performance of Type-2 and Type-4 drivers..??

 
abhishek pendkay
Ranch Hand
Posts: 184
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
do Type-2(part java part native) drivers offer better performance for SQL and PL-SQL operations as compared to Type-4(pure java) drivers..???
 
Scott Selikoff
author
Bartender
Posts: 4033
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There's no one right answer to the question, although here's a quick comparison chart from the JavaRanch Faq: JDBC Driver Types

In theory type 2 would be better, but I suggest you run actual performance comparisons on the types of queries and data you expect to run. There may be other issues such that the performance difference is negliable or possibly worse for using type 2.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!