The performance of your TSDB doesn’t just impact your ability to ingest, store, and analyze large amounts of data; it directly affects your total cost of ownership (TCO). Better ingestion rates, query response times and compression ratios mean your system consumes fewer resources to process the same amount of data. To demonstrate TDengine’s robust performance, we evaluated the platform against the recently released InfluxDB 3 in an IoT scenario.
Performance Comparison
Ingestion Performance
Time series databases need to ingest massive amounts of data, and TDengine achieves the fastest ingestion speeds across all datasets, ranging from 6 to 11 times the speed of InfluxDB.
Resource Consumption
In addition, TDengine uses less processing power than InfluxDB to ingest the datasets. While TDengine does require higher CPU usage, it completes all ingestion and compression tasks within 5 minutes while InfluxDB takes more than 5 times longer, meaning that the total resource usage of TDengine is lower.
Query Performance
As performance can differ based on a number of factors, the TSBS framework covers a wide range of query types. TDengine provided the fastest query response across all scenarios, confirming that organizations dependent on real-time analytics are best served with this purpose-built platform.
Notably, six of the twelve IoT query sets failed to run at all in InfluxDB 3 Core, either throwing an error or returning no results. This indicates that InfluxQL compatibility is still an issue for InfluxDB 3, and it is hoped that more complete results can be obtained once this is resolved.
Disk Storage
TDengine required less disk space to store the TSBS datasets in all scenarios and use cases. Its compression performance ranged from 2 to 7 times better than InfluxDB with significantly higher efficiency in the 100,000 devices and smaller-scale categories.
Conclusion
Across all key test metrics for ingestion, compression, and querying, TDengine clearly emerges as the highest-performing time series database.
- Ingestion: TDengine writes the test data between 6 to 11 times faster than InfluxDB, with significantly lower total CPU overhead.
- Compression: Due to its efficient data storage and compression features, TDengine consumes up to 7 times less disk space than InfluxDB.
- Queries: TDengine has the fastest query response time across all scenarios. For this use case, TDengine responds up to 153 times faster than InfluxDB.
Purpose-Built Design
Unlike all-purpose databases like MySQL or PostgreSQL, TDengine was designed from the ground up to simplify and scale time series data management. The platform’s innovative storage engine makes full use of the unique characteristics of time series data, with novel concepts like a single table for each data collection point, which enables better ingestion, and data compression, and supertables, which speed up aggregation operations.
Best in Class TSDB
The performance advantages shown by this evaluation indicate that TDengine excels at time-series data processing, especially with larger datasets and more complex queries. TDengine also requires fewer resources, significantly reducing the TCO of data operations. These advantages, combined with its comprehensive feature set and ease of use, make TDengine the best option for growing enterprises to scale their data pipelines.
