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

N1QL-FTS (QF2)throughput ~42% compared with N1QL (Q2 )

    XMLWordPrintable

Details

    • Untriaged
    • Unknown

    Description

      Throughput comparsion between QF2 vs Q2
       

        QF2 Q2
      index {
      "name": "",
      "type": "fulltext-index",
      "params": { "doc_config": \{ "docid_prefix_delim": "", "docid_regexp": "", "mode": "type_field", "type_field": "type" }

      ,
      "mapping": {
      "default_analyzer": "standard",
      "default_datetime_parser": "dateTimeOptional",
      "default_field": "_all",
      "default_mapping":

      Unknown macro: { "dynamic"}

      ,
      "default_type": "_default",
      "docvalues_dynamic": true,
      "index_dynamic": true,
      "store_dynamic": false,
      "type_field": "_type"
      },
      "store":

      { "indexType": "scorch", "kvStoreName": "" }

      },
      "sourceType": "couchbase",
      "sourceName": "bucket-1",
      "sourceUUID": "",
      "sourceParams": {},
      "planParams":

      { "maxPartitionsPerPIndex": 1024, "indexPartitions": 1, "numReplicas": 0 }

      ,
      "uuid": ""
      }

      		 CREATE INDEX by_email ON `bucket-1`(email);
      query statement = SELECT * FROM `bucket-1` AS t1 WHERE SEARCH(t1, {"explain": false, "query": {"field": "email", "match": $1}

      , "score":"none"},

      		 statement = SELECT * FROM `bucket-1` WHERE email = $1;
      memory 100 GB 100 GB
      Throughput (q/ps) 38249 66950
      jenkins url http://perf.jenkins.couchbase.com/job/iris/15900/console http://perf.jenkins.couchbase.com/job/iris-multi-client/3453/console

       

      Attachments

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

        Activity

          People

            abhinav Abhi Dangeti
            sharath.sulochana Sharath Sulochana (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty