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; ..........................
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
| |||
| 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 |
| |||
| 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! |
![]() |
| Thread Tools | |
| Display Modes | |
| |
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 |