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

14 ms increase in latency for Flex Queries

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Yes

    Description

      Test run. : 80th percentile latency (ms), Flex, Array predicates only, 10K KV w/sec, wiki 1M x 1KB, 3 node, FTS, s=1 c=1

      Measurements : 

      Build Latency (ms)
      7.0.2-6680 88.49
      ​7.0.2-6682 ​88.09
      7.0.2-6683 102

      Query run : 
      SELECT devices, company_name, first_name FROM " + flexTarget|
      USE INDEX( `perf-fts-index` USING FTS) WHERE (((ANY c IN children SATISFIES c.gender = "M" AND c.age <=8 AND c.first_name ="Aaron" END) OR (ANY num in devices SATISFIES num >= "070842-712" AND num<="070875-000" END) ) ) AND ((ANY num in devices SATISFIES num >= "060842-712" AND num<="060843-712" END) OR (ANY c in children SATISFIES (c.first_name ="Tyra" or c.first_name ="Aaron") AND c.gender = "F" AND c.age>=10 AND c.age<=13 END))OR(ANY c IN children SATISFIES c.gender = "F" AND c.age <=5 AND (first_name="Sienna" OR first_name= "Pattie" ) END );

      Change log : here 

      Attachments

        Issue Links

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

          Activity

            Notes for myself:  adapting to queue size (both up and down): 94.91 & 99.95.

            So not lingering over-sized queue it seems but simply gathering larger batches adversely impacts these queries.

            Donald.haggart Donald Haggart added a comment - Notes for myself:  adapting to queue size (both up and down): 94.91 & 99.95. So not lingering over-sized queue it seems but simply gathering larger batches adversely impacts these queries.

            Notes for myself:  forcing this down to a fixed size of 8 (i.e. below "normal"): 87.34 & 94.66

            Donald.haggart Donald Haggart added a comment - Notes for myself:  forcing this down to a fixed size of 8 (i.e. below "normal"): 87.34 & 94.66

            Build couchbase-server-7.1.0-1468 contains query commit e8ec4b0 with commit message:
            MB-48658 Flush batch sooner.

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1468 contains query commit e8ec4b0 with commit message: MB-48658 Flush batch sooner.

            Build couchbase-server-7.1.0-1472 contains query commit d69f22f with commit message:
            MB-48658 Revise fix to handle nil operator input.

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1472 contains query commit d69f22f with commit message: MB-48658 Revise fix to handle nil operator input.

            The fix results in a necessary compromise between these and other queries performance.  These benefit from small batches regardless of the queueing upstream; others perform best with large batches. 

            Therefore it is expected that there will be some impact to the latency figures for this test suite, but they should be better than with the initial fix for MB-48496.

            Donald.haggart Donald Haggart added a comment - The fix results in a necessary compromise between these and other queries performance.  These benefit from small batches regardless of the queueing upstream; others perform best with large batches.  Therefore it is expected that there will be some impact to the latency figures for this test suite, but they should be better than with the initial fix for MB-48496 .

            People

              jyotsna.nayak Jyotsna Nayak
              jyotsna.nayak Jyotsna Nayak
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty