Home » Oracle FAQ Knowledge Base » Middleware » ODBC

How fast is ODBC?

Submitted by admin on Wed, 2005-11-09 13:50.

According to Oracle, their ODBC driver, on average, runs about 3% slower than native Oracle access.

My experience, however, is that ODBC can be extremely slow!!!

    ‹ How secure is ODBC?upHow can I test if ODBC is setup correctly? ›
    »

    Oracle ODBC performance depends on driver

    Submitted by Marsha (not verified) on Mon, 2006-04-24 17:34.

    >> According to Oracle, their ODBC driver, on average, runs about 3% slower than native Oracle access.

    My experience, however, is that ODBC can be extremely slow!!!
    ----------------------------------------
    ODBC is a programming interface, not an implementation. Performance depends on the implementation of the interface. There are several types of ODBC drivers for Oracle. Here's a white paper with benchmarks comparing OCI and ODBC performance:

    http://www.datadirect.com/techres/odbc/docs/wp_odbcvsoci.pdf

    »