<div>
<div class="content wysiwyg-content">
I'm in the process of design a data loading structure into an Oracle database. As I know there are few options available, ODBC, OCI, SQL Loader. Yes almost all of the data will be direct load without much referencing or lookup, so I assume SQL Loader will provide the best performance out of the 3, but what about just between ODBC vs OCI, or if SQL Loader is the best performer, how much is it out perform the others?<br />
<br />
thanks<br />
Ku
</div>
</div>


I'm in the process of design a data loading structure into an Oracle database. As I know there are few options available, ODBC, OCI, SQL Loader. Yes almost all of the data will be direct load without much referencing or lookup, so I assume SQL Loader will provide the best performance out of the 3, but what about just between ODBC vs OCI, or if SQL Loader is the best performer, how much is it out perform the others?

thanks
Ku

Load Perf : ODBC vs OCI vs SQL Loader

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.