What is the fastest type of JDBC driver ?

Fastest is Type 4 (Thin) driver

 

JDBC driver performance will depend on a number of issues

• Quality of the driver code
• Size of the driver code
• Database server and its load
• Network topology
• 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.

FACTS

• Type 1 and Type 3 drivers will be slower than Type 2 drivers
  The database calls are make at least 3 translations vs. 2
• Type 4 drivers are the fastest (only one translation)
• Fastest : Type 4 -> Type 2 -> Type 1 and 3