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)