TDengine icon indicating copy to clipboard operation
TDengine copied to clipboard
verified publisher icon taosdata

包含 BLOB 类型字段，使用 order by ts desc 查询十分缓慢

Open sayhitocc opened this issue 2 months ago • 4 comments

Performance Issue 当字段中含有blob 类型数据时，order by ts desc 的查询将十分缓慢，数据 200w 条

Screenshots

Image Image

Environment (please complete the following information):

  • OS: centos9
  • Memory, CPU, current Disk Space: 16G内存，2.4T存储空余
  • TDengine Version: 3.3.7.5

sayhitocc avatar Oct 28 '25 07:10 sayhitocc

去掉 blob 再执行一下，截图看看

yu285 avatar Oct 28 '25 08:10 yu285

Image. 去掉后查询速度很快。 @yu285

sayhitocc avatar Oct 31 '25 04:10 sayhitocc

请问有什么进展吗？ 谢谢@yu285

sayhitocc avatar Nov 03 '25 03:11 sayhitocc

后面会对这个查询进行优化，请关注后续版本

ZeLv01 avatar Dec 04 '25 01:12 ZeLv01