包含 BLOB 类型字段，使用 order by ts desc 查询十分缓慢
Open
@yu285 is already working on this.
Since Oct 28, 2025.
performance
- Dominant language
- C
- Stars
- 25.1k
- Forks
- 5k
- Avg merge
- 4d 59m
- Merged PRs (30d)
- 7
Description
Performance Issue
当字段中含有blob 类型数据时，order by ts desc 的查询将十分缓慢，数据 200w 条
Screenshots
Environment (please complete the following information):
- OS: centos9
- Memory, CPU, current Disk Space: 16G内存，2.4T存储空余
- TDengine Version: 3.3.7.5
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.