by Jerod Johnson | October 18, 2019

High Performance Drivers for Amazon DynamoDB

Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. DynamoDB enables you to have a dynamic, scalable database without worrying about hardware provisioning, setup and configuration, replication, software patching, or cluster scaling. Because of the virtually unlimited server-side resources available for DynamoDB instances, you want to be sure that your client applications and connections are keeping up.

At CData Software, we provide high-performance data drivers for a variety of data sources, including Amazon DynamoDB. Since we specialize in drivers, we are able to invest in fine-tuning and optimizing our drivers to offer the industry's fastest connectivity. Our drivers provide faster read access from DynamoDB by optimizing the use of client-side resources like CPU utilization & network usage and making better use of the configurable resources in DynamoDB.

In this post, we briefly compare the performance of our DynamoDB Drivers to that of competitor drivers and include a link to a more in-depth comparison article with detailed data.

Amazon DynamoDB Driver Performance

For Amazon DynamoDB, we compared our JDBC Driver to a competitor offering. In addition to read performance and client-side resource usage, we also compared the DynamoDB CloudWatch metrics for each offering, measuring how much of the allocated Read Units the drivers were consuming. We outline the results here and include a link to the full article.

Read Performance

The CData JDBC Driver read large datasets from DynamoDB over 5.5x faster than the competitor driver.

JDBC Query Times by Company (in seconds)
Rows Queried CData Software Competitor
~10,000,000 139.83 (+462.4%) 786.37

JDBC Client Resources

When we provision a high read capacity (1000 read units) on the DynamoDB instance, the differences in how each driver utilizes available client-side resources are stark. Based on the graph, the CData Driver maintains a higher client-side resource usage, but does so for a significantly shorter amount of time than the competitor driver.

* Note the change in scale for the Heap graph.

Read Capacity Consumption

Based on the graph, we can see that the CData Driver makes significantly better use of the provisioned read capacity, utilizing around 70% of the available read capacity units. Meanwhile, the competitor driver uses less than 20% of the available read capacity (despite being configured in the JDBC URL to use 100%).

DynamoDB CloudWatch Metrics

Read the Article

For more information, including a full description of the data queried, read the full comparison article in our Knowledge Base.

Continue to the Amazon DynamoDB Article »

Free Trial & More Information

Thanks to the CData Drivers, DynamoDB users can connect to live DynamoDB data faster than with any other connector. This speed enables ad-hoc querying of DynamoDB data, saves users money (by reducing the amount of time required for high resource allocation), and enables responsive reporting, dashboards, and more.

Check out our DynamoDB page for more information on our drivers for DynamoDB, including popular integrations. Download a free, 30-day trial of any of our drivers to see the CData difference for yourself.