ODBC / JDBC - Which one is fast

[unirams]

Hi folks,

Is there any idea about the difference between ODBC and JDBC? I heard that ODBC is much faster than JDBC. If so, please let us know why? As i am in the need of converting my existing tool from Windows specific to cross platform, i am going to recode the same tool in Java. Quick Response for this question is highly appreciated and thankful.

Thanks in advance.

Regards,
Ram

 

[StukA]

The speed difference between ODBC and JDBC is pretty simple - the JDBC code must use a JVM to get to the hardware/OS, while ODBC, being written in C/C++, gets straight through. Newer, faster JVMs will improve the difference (the most notable speed lag in most Java apps is in the JVM startup these days), but there will be some lag as long as the JVM is involved.