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

[FTS] up to 10x performance degradation when using large "query size" (limit) setting

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.0.0
    • 5.0.0
    • fts
    • Untriaged
    • No

    Description

      Despite the actual amount of hits returned large "limit" impacts the throughput.

      Some numbers:

      Small dataset, low frequency terms, the search query returns only 1 hit.

      size = 1, throughput = 21k

      size = 10, throughput = 20k

      size = 100, throughput = 9k

      size = 1000, throughput = 2k

       

      Attachments

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

        Activity

          People

            oleksandr.gyryk Alex Gyryk (Inactive)
            oleksandr.gyryk Alex Gyryk (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty