Yuan Tian created IOTDB-6310:
--------------------------------

             Summary: Optimize for query resource init
                 Key: IOTDB-6310
                 URL: https://issues.apache.org/jira/browse/IOTDB-6310
             Project: Apache IoTDB
          Issue Type: Improvement
          Components: Core/Query
            Reporter: Yuan Tian
            Assignee: Yuan Tian


we use timefilter to filter useless timepartition instead of getting all of 
them and then filter tsfile in them one by one.

We insert `0~9999` points whose timestamp is also `0~9999` and execute `flush` 
after each point insert and then insert one point with timestamp now(). As so, 
we will get two partitions, one contains 10,000 tsfiles, another one contains 
only one tsfile.

execute the following sql: (only the last tsfile satisfies)
```
select s1 from root.db.d1 where time > now() - 1h;
```

before opt, the time for query init tsfile list are:(about 2.5ms)

```
3057000
2356292
3258834
2415417
2876041
2395750
2564833
```

after opt, the time for query init tsfile list are:(about 0.047 ms)
```
47500
39792
33875
31958
37584
56666
45709
```

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to