| Author |
performance of Type-2 and Type-4 drivers..??
|
abhishek pendkay
Ranch Hand
Joined: Jan 01, 2007
Posts: 184
|
|
|
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..???
|
The significant problems we face cannot be solved by the same level of thinking which created them – Einstein
SCJP 1.5, SCWCD, SCBCD in the making
|
 |
Scott Selikoff
Saloon Keeper
Joined: Oct 23, 2005
Posts: 3652
|
|
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.
|
My Blog: Down Home Country Coding with Scott Selikoff
|
|
 |
|
|
subject: performance of Type-2 and Type-4 drivers..??
|
|
|
0
