Comparing jdbc-thin versus jdbc-oci


TEST ENVIRONMENT

An OEL Dropbox VM macchine running on Intel i5 laptop 8Gb RAM 250 Gb SAS disk

The VM is the “Oracle Big Data Lite Virtual Machine 12c” located here http://www.oracle.com/technetwork/database/bigdata-appliance/oracle-bigdatalite-2104726.html#download_bdalite

The VM is configured with 6810MB and 3 vcpus

TEST ARTIFACTS

Here the link to the java project utilized for the test

Here a shell script sample

Here test data sample

Here sql DDL/DML data sample

TEST EXPLANATION

The test repeats a connection/select-fetch/disconnect pattern the specified number of tries.

The test has been run with different table row sizes, ant he response patter is always simillar.

TEST RESULTS

The following chart shows the response times, jdbc-oci takes near 20% more time in average.

jdbc thin-oci comp

Please note that this results can’t be extrapolated to results obtained in native OCI implementations.

DISCLAIMER

This results are only for demonstration purposes and haven’t been verified.

The test equipment haven’t been optimized nor tuned.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.