Friday, March 13, 2009

What is the fastest type of JDBC driver (JDBC)

Question :What is the fastest type of JDBC driver? (JDBC)
Answer :JDBC driver performance will depend on a number of issues:
(a) the quality of the driver code,
(b) the size of the driver code,
(c) the database server and its load,
(d) network topology,
(e) 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).

No comments: