Home Services Partners Company
DataDirect MySQL ODBC Performance with MemSQL

DataDirect MySQL ODBC Performance with MemSQL

November 24, 2015 0 Comments

Our experiment shows that the DataDirect® MySQL driver is ~37% faster than the native MySQL driver when used with MemSQL and Tableau. But don’t take our word for it, take a look at the data.

How Commercial MySQL ODBC Drivers Perform

DataDirect drivers are designed to be the fastest and most reliable connectivity solutions in the industry. For today, let’s take a look at MemSQL (a fast in-memory database) and the DataDirect MySQL driver (a fast ODBC driver). MemSQL is compatible with the MySQL protocol, and therefore works the commercial DataDirect MySQL ODBC driver that supports InnoDB, MiISAM and Memory storage engines.

So, the question you might have is what makes the DataDirect MySQL driver unique, when compared to the native MySQL driver typically used with MySQL and MemSQL? To check this, we conducted an experiment with Tableau data visualization software and a MemSQL database as our data source. We then used a DataDirect MySQL driver and a Native MySQL driver as connectivity solutions, and compared the performance between the two drivers.

The performance of each driver was calculated using Tableau’s performance recording tool. As a part of this experiment we used both drivers to fetch and also to generate an extract for 300k, 600k and 1 million records from the MemSQL datasource to Tableau.

The Results

The following are the performance metrics measured by Tableau for native MySQL and DataDirect MySQL driver.

  1. 300k Records

    Figure 1: Native MySQL Driver Performance300k records

    Events sorted by Time

     

    Figure 2: DataDirect MySQL Driver Performance300k records

    Events sorted by time

     

  2. 600k Records

    Figure 3: Native MySQL Driver Performance600k records

    Events Sorted by Time

     

    Figure 4: DataDirect MySQL Driver Performance600k records

    Events Sorted by Time

     

  3. 1 Million records

    Figure 5: Native MySQL Driver Performance1 million records

Events Sorted by Time

Figure 6: DataDirect MySQL Driver Performance—1 million records

Events Sorted by Time

 

DataDirect MySQL is Faster than Native MySQL

From the above generated metrics, you can see that the DataDirect MySQL driver is ~37% faster than the Native MySQL driver when used with MemSQL and Tableau. We know how speed is important to your business, especially for MemSQL shops, and DataDirect drivers are designed to maintain their speed and reliability despite your demanding needs. This is one simple experiment around performance that demonstrates how DataDirect drivers can improve your productivity on daily basis. Special thanks to Saikrishna Teja Bobba, Developer Evangelist with Progress DataDirect, who helped run these tests.

See for Yourself

Feel free to try DataDirect connectivity drivers yourself. Our engineers work hard to deliver top performance and we're proud of the amazing experience our DataDirect drivers provide.

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 What Is Data Democratization and Why Do You Need It?
Comments
Comments are disabled in preview mode.