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.
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 following are the performance metrics measured by Tableau for native MySQL and DataDirect MySQL driver.
Figure 1: Native MySQL Driver Performance—300k records
Figure 2: DataDirect MySQL Driver Performance—300k records
Figure 3: Native MySQL Driver Performance—600k records
Figure 4: DataDirect MySQL Driver Performance—600k records
1 Million recordsFigure 5: Native MySQL Driver Performance—1 million records
Figure 6: DataDirect MySQL Driver Performance—1 million records
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.
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.
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.Learn More
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You can also ask us not to share your Personal Information to third parties here: Do Not Sell or Share My Info
We see that you have already chosen to receive marketing materials from us. If you wish to change this at any time you may do so by clicking here.
Thank you for your continued interest in Progress. Based on either your previous activity on our websites or our ongoing relationship, we will keep you updated on our products, solutions, services, company news and events. If you decide that you want to be removed from our mailing lists at any time, you can change your contact preferences by clicking here.