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

            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