by Jerod Johnson | June 01, 2021

Enhanced Performance In New V21 ODBC Drivers

Years ago, we released Mac and Unix/Linux versions of our ODBC Drivers, bringing standardized connectivity to SaaS, Big Data, and NoSQL sources regardless of your computing environment. With the 2021 release of our Drivers, our engineering team has reworked the core of our Mac/Unix ODBC Drivers.

This re-engineering creates no change in how our customers use or configure the drivers, but it leads to some dramatic improvements in performance when it comes to working with large datasets.

Significantly Faster Read Performance

To test, we configured our ODBC drivers to connect to a Snowflake data warehouse. We queried successively larger data sets with the 2020 and 2021 drivers to compare the differences in read performance and memory usage.

Upgraded Query Execution

With the updated ODBC drivers, large datasets are regularly read 50% faster than with the older versions.

ODBC Query Times by Version (in seconds)
Number of Rows Queried 2020 Release 2021 Release
100,000 9.71 4.26 (+56%)
1,000,000 29.16 14.68 (+49%)
10,000,000 254.98 123.63 (+52%)

Client Resources

One of the reasons for the improved read performance is better utilization of available client resources. By leveraging more client-side memory, the updated ODBC Drivers can process more information, faster than the previous version.

Client-Side Resource Usage (in MB)
Number of Rows Queried 2020 Release 2021 Release
100,000 90.98 325.07
1,000,000 141.12 631.79
10,000,000 369.49 743.58

Improvements for All Mac/Unix ODBC Drivers

The improved performance applies to our Snowflake ODBC Drivers and all 250+ SaaS, Big Data, and NoSQL data sources supported by our ODBC Drivers. With the newly released 2021 drivers, you can expect faster reading of large datasets in Mac & Unix environments, regardless of the BI, reporting, ETL, or custom application where you're working.

Get Started Today

Download a free, 30-day trial of any of our ODBC Drivers and see the CData difference in your data tooling for Mac & Unix environments today.

Download The New 2021 ODBC Drivers