Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

choose jdbc driver type

 
kri shan
Ranch Hand
Posts: 1467
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What are the basic criteria to choose jdbc driver type ?
 
Frederic Filiatrault
Ranch Hand
Posts: 69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Depending on what you want to do, I'll say get the latest version of Type 4, which is the fastest. Try to use Stored Procedure, is it faster or if you cannot, use ANSI SQL with inner join, which is 40% faster that normal queries.

Hope this will help !
 
Gregg Bolinger
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Since this question has nothing to do with Servlets, I'll move it to JDBC where all the Database junkies hang out.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic