You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "刘珍 (Jira)" <ji...@apache.org> on 2022/03/31 03:29:00 UTC

[jira] [Created] (IOTDB-2829) [template query performance] The query performance with templates is slower than that without templates

刘珍 created IOTDB-2829:
-------------------------

             Summary: [template query performance] The query performance with templates is slower than that without templates
                 Key: IOTDB-2829
                 URL: https://issues.apache.org/jira/browse/IOTDB-2829
             Project: Apache IoTDB
          Issue Type: Bug
          Components: Core/Query
    Affects Versions: 0.14.0-SNAPSHOT
            Reporter: 刘珍
            Assignee: Yuan Tian


rel/0.13 60f90977a88f767c7ca86c6e10f1471bba262c2f
问题描述:
相同数据量,有乱序,带模板的查询性能比不带模板慢:
 !image-2022-03-31-11-13-10-183.png! 

测试流程
1. 测试环境
192.168.10.68机器
{color:#DE350B}*关合并*{color}
带template的数据备份在/data/benchmark/weekly_shell/rel_13_rc1_data_bk/data_3_luanxu
不带template的数据备份在/data/benchmark/weekly_shell/rel_13_rc1_data_bk/data_1_luanxu
数据库路径:
${IOTDB_DIR}=/data/liuzhen_test/weekly_0127/13_rc1
benchmark工具路径:
${benchmark_dir}=/data/benchmark/weekly_shell/benchmark_tool_20220322_v13

2. 测试流程
for i in {Q1..Q10} do
    清OS缓存,copy 数据备份到${IOTDB_DIR},启动数据库。
    copy Qi..config.properties查询的配置文件到${benchmark_dir}
    启动benchmark查询,记录结果
done
查询语句的benchmark配置文件见附件:

对比结果,带template的查询耗时长。





--
This message was sent by Atlassian Jira
(v8.20.1#820001)