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

            Build sync_gateway-2.7.4-4 contains sync_gateway commit b47a4ee with commit message:
            CBG-885: Backport CBG-882 (#4780)

            build-team Couchbase Build Team added a comment - Build sync_gateway-2.7.4-4 contains sync_gateway commit b47a4ee with commit message: CBG-885 : Backport CBG-882 (#4780)

            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