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.
To evaluate the performance of these drivers, I have used the following setup.
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.
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.
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.
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.
Learn more and start a trial of the DataDirect Sequelink JDBC-ODBC adapter.
Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.