Details
-
Bug
-
Resolution: Fixed
-
Critical
-
2.8.0, 2.7.1, 2.7.2
-
Security Level: Public
-
None
-
CBG Sprint 57
-
3
Description
The channels query ORDER BY that was added for safety results in performance degradation for very large channels. It should be rewritten to align with the index definition:
ORDER BY [op.name, LEAST(meta(`write`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)]
Also need to review performance scenarios to understand why this degradation wasn't identified there.
Attachments
Issue Links
- Clones
-
CBG-882 Align channels query ORDER BY with index
- Closed