Skip to content

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

@sayhitocc

Description

@sayhitocc

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

Metadata

Metadata

Assignees

Labels

performancePerformance-related questions

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions