Uploaded image for project: 'Couchbase Gateway'
  1. Couchbase Gateway
  2. CBG-885

2.7.4 Backport CBG-882 - Align channels query ORDER BY with index

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 2.7.4
    • 2.8.0, 2.7.1, 2.7.2
    • SyncGateway
    • 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

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              jacques.rascagneres Jacques Rascagneres
              adamf Adam Fraser
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty