You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Yuan Tian (Jira)" <ji...@apache.org> on 2023/03/22 12:18:00 UTC
[jira] [Created] (IOTDB-5715) Improve the performance of query order by time desc
Yuan Tian created IOTDB-5715:
--------------------------------
Summary: Improve the performance of query order by time desc
Key: IOTDB-5715
URL: https://issues.apache.org/jira/browse/IOTDB-5715
Project: Apache IoTDB
Issue Type: Improvement
Components: Core/Query
Reporter: Yuan Tian
Assignee: Yuan Tian
Fix For: 1.2.0
Attachments: data.zip
We found that order time desc is much slower than order by time asc.
We can use the data in attachment and start a 1C1D IoTDB to replay that.
```
select * from root.sg1.d1 where s1 != 1 order by time asc;
select * from root.sg1.d1 where s1 != 1 order by time desc;
```
--
This message was sent by Atlassian Jira
(v8.20.10#820010)