[IOTDB-5715] Improve the performance of query order by time desc

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0
• Component/s: Core/Query
• Labels: pull-request-available
• Sprint: 2023-3-Query
• Assignee: Yuan Tian
• Reporter: Yuan Tian
• Created: 22/Mar/23 12:17
• Updated: 23/Mar/23 02:52
• Resolved: 23/Mar/23 02:52

Description

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;

```

Issue Links

• links to: GitHub Pull Request #9412
• links to: GitHub Pull Request #9414