使用 benmark 写入数据:


precise_pointtime_rangevalue_rangeagg_rangeagg_valueagg_range_valuegroup_bylastest_point
对齐时间序列2.693.4126.724.36180000ms28.344.671.61
非对齐时间序列2.872.7827.652.69超时20.943.221.73
okPoint
117601225010000
10000130000


108101128010000
10000130000

自行写入数据,单设备,10个测点,时间范围 0 ~ 1亿,共10亿个点,value 值和时间值相同。

String no_vector1 = "select count(*) from root.sg1.d1";
// 10 sensor with value filter with time range
String no_vector2 = "select count(*) from root.sg.d1 where time < %d and s0 < %d and s1 < %d and s2 < %d and s3 < %d "
+ "and s4 < %d and s5 < %d and s6 < %d and s7 < %d and s8 < %d and s9 < %d";

LOOP = 1000次

sql1 agg_allsql2 agg_value_rangesql3 single_sensor_raw_query
对齐时间序列(未优化分支)130ms1734ms
对齐时间序列(优化分支)127ms1305ms24563ms
非对齐时间序列617ms843ms21522ms

对齐时间序列












非对齐时间序列





  • No labels