IT Community - Software Programming, Web Development and Technical Support

Which is the fastest type of JDBC driver in Java?

This is a discussion on Which is the fastest type of JDBC driver in Java? within the Java Programming forums, part of the Software Development category; ..........................


Go Back   IT Community - Software Programming, Web Development and Technical Support > Software Development > Java Programming

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 09-04-2007, 07:52 AM
leoraja8 leoraja8 is offline
D-Web Sr.Programmer
 
Join Date: May 2007
Posts: 194
leoraja8 is on a distinguished road
Post Which is the fastest type of JDBC driver in Java?

.......................
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 09-04-2007, 07:59 AM
amansundar amansundar is offline
D-Web Analyst
 
Join Date: May 2007
Posts: 325
amansundar is on a distinguished road
Default Re: Which is the fastest type of JDBC driver in Java?

JDBC driver performance will depend on a number of issues:
the quality of the driver code,

the size of the driver code,
the database server and its load,
network topology,
the number of times your request is translated to a different API.
In general, all things being equal, you can assume that the more your request and response change hands, the slower it will be. This means that Type 1 and Type 3 drivers will be slower than Type 2 drivers (the database calls are make at least three translations versus two), and Type 4 drivers are the fastest (only one translation
__________________
cheers
Aman
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 09-05-2007, 08:31 AM
S.Vinothkumar S.Vinothkumar is offline
D-Web Genius
 
Join Date: May 2007
Posts: 1,061
S.Vinothkumar is on a distinguished road
Wink Re: Which is the fastest type of JDBC driver in Java?

Type 4: Direct-to-Database Pure Java Driver is fastest driver.

because, this style of driver converts JDBC calls into the network protocol used directly by DBMSs, allowing a direct call from the client machine to the DBMS server and providing a practical solution for intranet access.
__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Top fastest growing queries in US on Google caldwell880 Technology BUZZzzzzz 1 01-19-2008 10:19 AM
QTP-Design the driver code Shanthi Testing Tools 1 11-13-2007 06:23 AM
JAVA Oracle connectivity with Jdbc-odbc bridge amansundar Java Programming 4 09-24-2007 11:59 PM
Making Your Bluetooth dongle Windows Driver Compatible (Microsoft) itbarota Computer Hardware 2 08-06-2007 09:17 AM
What’s the fastest way to read 1 million lines from an Apache log file with PHP? oxygen PHP Programming 1 07-26-2007 03:28 AM


All times are GMT -7. The time now is 11:12 PM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.

SEO by vBSEO 3.0.0