The second query ("SELECT _id, grades, avg_score. " query, there are over 170 million data points to read (over 1.5 million rows times 11 columns) and the CData Driver is able to read the results in approximately 67% of the time it takes the MySQL Driver. The results are displayed in the table below.Īs can be seen in the results, the CData Driver significantly outperformed the native MySQL Driver and MariaDB when working with large result sets and was comparably performant for other queries.įor the "SELECT *. We performed this operation fifty times per driver and then calculated the average runtime for the set of fifty runs for each query. The queries above have varying numbers of results and will showcase each driver's ability to manage both large and small result sets.įor each driver, we established a connection to the database and ran all four queries back-to-back.
We did this by running the same four queries with each driver. The main goal of this investigation was to compare the related performance of the drivers. The dataset consists of 1,546,899 rows of data (3.45 GB) where each row contains information about a restaurant. | cuisine | varchar(255) | YES | | NULL | | | borough | varchar(255) | YES | | NULL | | | restaurant_id | bigint(20) | NO | | NULL | | | building | varchar(127) | YES | | NULL | | | address_coord | varchar(255) | YES | | NULL | | | address_zipcode | int(11) | YES | | NULL | | | address_street | varchar(255) | YES | | NULL | | | grades | varchar(2000) | YES | | NULL | | | Field | Type | Null | Key | Default | Extra | To begin the comparison, we created a new database in MySQL and then created a table called "restaurant", described below:
#Mysql jdbc driver for mac drivers#
Since the drivers are being compared side-by-side, the performance of the machine itself is relatively unimportant what matters is how the drivers compare relative to one another.Īs a side note, we had plans to include other commercial JDBC drivers in our comparison, but they did not support connecting to the Community Edition of MySQL Server. Processor: Intel® Core TM i3-2120 CPU 3.30GHz
#Mysql jdbc driver for mac windows 7#
Operating System: Windows 7 Ultimate, SP1 The test machine specifications are as follows: In order to provide a benchmark, we installed MySQL Server 5.7 on a test machine and inserted a relatively large dataset into the database. This article will serve to compare the native, open-source JDBC Driver from MySQL (Connector/J 1), the MariaDB (a popular MySQL fork) Connector/J 2, and the licensed JDBC Driver from CData (JDBC Driver for JDBC 2016 3). There are several native, open-source drivers available for connecting to your MySQL data from other applications. In fact, many cloud databases have adopted the MySQL interface over other options. MySQL is "The world's most popular open source database" and provides a robust, widely-used way to store and access your data.