High-Performance Time-Series Database

TDengine is a high-performance time-series database (TSDB) featuring a novel storage engine that makes full use of the characteristics of time-series data. This engine significantly improves the speed of querying and ingesting data, as well as the compression ratio of the data it stores. With only a single core, TDengine can process over 20,000 requests, insert millions of data points, and read more than 10 million data points per second. It is at least 10 times faster than general databases, and its data compression ratio is at least 5 times higher.

Using the test framework, data sets and test scenarios provided by InfluxDB, the following can be shown:

  • TDengine provides ingestion throughput at least 2 times higher than InfluxDB, and up to 5.2 times higher when the number of devices exceeds 1000.
  • For query scenarios, a few have the same speed as InfluxDB, while the majority are several times faster, and some are up to 40 times faster.
  • For data compression, both TDengine and InfluxDB have very good performance, but TDengine’s storage size is only 70% of InfluxDB’s.
Comparison of data ingestion time for high-performance time-series databases
Figure 1. Data ingestion time for TDengine and InfluxDB
Comparison of data fetch time for high-performance time-series databases
Figure 2. Data fetch time for TDengine and InfluxDB

Figure 1 makes it clear that TDengine outperforms InfluxDB in data ingestion as the number of devices increases. When the number of devices is 1000, InfluxDB takes 5.2 times longer to insert all the data. For a complete ingestion comparison test with InfluxDB, including detailed steps and results, see Writing Performance Comparison of TDengine and InfluxDB.

Figure 2 shows that with 16 devices, InfluxDB takes 8.78 times longer to complete the query operation. When the number of devices is 128, InfluxDB takes 9.37 times longer time than TDengine. When the number of devices is 256, InfluxDB is not able to respond. For a complete query comparison test with InfluxDB, including detailed steps and results, see Query Performance Comparison Test Report: TDengine vs. InfluxDB.

With a higher number of devices such as 10,000, InfluxDB stopped responding. You can follow the steps in the testing report and set the configuration accordingly to see for yourself how TDengine and InfluxDB would perform in your scenario.

For comparison test reports with other databases such as MongoDB, ClickHouse, and OpenTSDB, see TDengine Performance Comparison.

TDengine is an outstanding high-performance time-series database thanks to the novel design of its storage engine and concepts such as “one table per data collection point” and the supertable. For more information, see Architecture.

Learn more about TDengine: