Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

[BP to 7.1.2] - Improve pagination queries with fetch

Description

Above query not covered, not using index order so pagination not passed to indexer.
So end up fetching all qualified documents (instead of LIMIT only documents), then sort and apply pagination.

Here Indexer has all the information in predicate and order by (projection info is not there)

Alternative is as follows but very inconvenient.

Components

Affects versions

Fix versions

Labels

Environment

None

Release Notes Description

None

Activity

Show:

CB robot October 7, 2022 at 8:56 AM

Build couchbase-server-7.2.0-5000 contains query-ee commit c2b9cb8 with commit message:
Perform SORT early when possible to save on FETCH

CB robot October 7, 2022 at 8:56 AM

Build couchbase-server-7.2.0-5000 contains query commit ac472ee with commit message:
Perform SORT early when possible to save on FETCH

CB robot October 7, 2022 at 8:56 AM

Build couchbase-server-7.2.0-5000 contains query commit bba78ef with commit message:
Perform OFFSET early when possible

CB robot October 7, 2022 at 8:56 AM

Build couchbase-server-7.2.0-5000 contains query commit 82aee67 with commit message:
Remove cached value attachements for early order

Ajay Pal Bhullar July 15, 2022 at 4:31 PM

verified via automation and manual testing in 7.1.2

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Story Points

Priority

Instabug

Open Instabug

PagerDuty

Sentry

Zendesk Support

Created May 23, 2022 at 5:19 PM
Updated October 7, 2022 at 8:56 AM
Resolved May 26, 2022 at 4:58 PM
Instabug