Home Services Partners Company
JDBC-ODBC Bridge Replacement Yields 310% Performance Boost

JDBC-ODBC Bridge Replacement Yields 310% Performance Boost

July 25, 2016 0 Comments

Performance tests reveal that the Progress DataDirect Sequelink JDBC-ODBC adapter is up to 310% faster than the Sun JDBC-ODBC bridge.

The DataDirect Sequelink JDBC-ODBC adapter serves as the trusted replacement for the JDBC-ODBC bridge. Even Oracle Data Integration recommends DataDirect SequeLink, after deprecating the JDBC-ODBC bridge in JDK 8. This adapter is extremely useful when you need connectivity to legacy data sources or when organizations need JDBC connectivity and only ODBC drivers are available.

Conversely, the DataDirect SequeLink ODBC-JDBC adapter serves as the adapter for scenarios where ODBC access is required, and only JDBC drivers exist, such as Apache Solr, Apache Phoenix or Neo4j.

As organizations turn to DataDirect for a JDBC-ODBC bridge replacement, we wanted to provide some performance indications so you can consider a replacement before moving to JDK 8. Our developer evangelist, Saikrishna Teja Bobba, ran the following tests.

Environment and Tools Used

To evaluate the performance of these drivers, I have used the following setup.

  • Server: MemSQL 5.1.0 hosted on Cloud VM with 7GB RAM and 4 cores CPU
  • Client: Windows 7 64 bit VM with 4GB RAM and 2 Cores CPU
  • ODBC Driver: Native MySQL 32 bit ODBC Driver 5.3.6
  • Measuring Tool: Apache Jmeter 3.0

Results

Results

Plot of Time taken (in milliseconds) vs Number of records that are pulled through using JDBC-ODBC bridge drivers

(Lower is Better)

From these numbers you can see that DataDirect Sequelink JDBC-ODBC adapter is 3X times faster than the Sun JDBC-ODBC drivers. Along with Oracle recommending us as a replacement to the Sun JDBC-ODBC bridge, we add production ready quality and improved performance for your application as part of this transition.

Testing Methodology

We tested these JDBC-ODBC bridges with data pull loads of 300K, 600K and 1 million records. For each load, the test was performed three times and an average value was calculated. This testing mechanism was configured in Apache Jmeter and the average latency values were recorded from there.

Why did we use a Native MySQL ODBC driver, instead of our in-house DataDirect MySQL ODBC drivers?

The reason we used the Native MySQL ODBC driver was to have a fair competition between the drivers. We didn’t want people to think that our Sequelink JDBC-ODBC bridge driver had an advantage because we used our in-house MySQL drivers.

If you're wondering whether our DataDirect MySQL drivers are in fact faster than Native MySQL drivers—the answer is yes. You can read this blog where we published the results of a comparison between the DataDirect MySQL driver and the Native MySQL driver.

Why did we use MemSQL as data source, when it already has a JDBC driver?

The main purpose of this performance test was to calculate how fast these JDBC-ODBC bridges could communicate JDBC calls to the ODBC API and get the data. To put it simply, we are only interested in calculating the overhead when using these bridges. We are not interested in how fast these data sources can serve the results.

Get Started

Learn more and start a trial of the DataDirect Sequelink JDBC-ODBC adapter.

Try Now

Sumit Sakar

Sumit Sarkar

Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others. 

Read next DataDirect MySQL ODBC Performance with MemSQL
Comments
Comments are disabled in preview mode.