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.
| 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.
| 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
