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

8% throughput penalty using use keys [] vs scalar use keys

    XMLWordPrintable

Details

    • Task
    • Resolution: Fixed
    • Major
    • 6.5.0
    • 6.5.0
    • query

    Description

      Q1 uses a request of the form

      select * from default use keys [$1]

      If I change the request to ... use keys $1, on my little performance testbed throughput improves from 15500 req/sec to 16700 (a good 8%).
      While we should change Q1 on perfrunner, we should also make scanning the array faster in the key scan operator.

      Attachments

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

        Activity

          People

            marco.greco Marco Greco (Inactive)
            marco.greco Marco Greco (Inactive)
            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