Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-19763

Provide improve result count estimation for pagination use cases.

    XMLWordPrintable

Details

    Description

      Is there any built in function in N1QL which is equivalent of SQL_CALC_FOUND_ROWS AND FOUND_ROWS() in MySQL to use with LIMIT , OFFSET for prepare Pager purposes?

      If no what is the best workaround to achieve same result rather than execute additional N1QL query mentioned below

      SELECT COUNT(id) FROM mybucket WHERE <same condition that get first result set>

      Attachments

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

        Activity

          People

            keshav Keshav Murthy
            keshav Keshav Murthy
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty