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

some timex queries are 10x slower

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • Cypher
    • Cypher
    • secondary-index
    • None
    • Untriaged
    • 0
    • Unknown

    Description

      create bucket b1

      load siftsmall 

      for idx, x in enumerate(docs):
                      doc = {
                          "id": idx,
                          "size":6,
                          "brand":"nike",
                          "vec": x.tolist()
                        }

       

       

      CREATE INDEX ix1 ON b1(size, brand, vec VECTOR, id) WITH {"dimension":128, "train_list":10000, "description": "IVF,PQ32x8", "similarity": "L2_SQUARED"};
      WITH qvec AS ([1.0, 3.0, 11.0, 110.0, 62.0, 22.0, 4.0, 0.0, 43.0, 21.0, 22.0, 18.0, 6.0, 28.0, 64.0, 9.0, 11.0, 1.0, 0.0, 0.0, 1.0, 40.0, 101.0, 21.0, 20.0, 2.0, 4.0, 2.0, 2.0, 9.0, 18.0, 35.0, 1.0, 1.0, 7.0, 25.0, 108.0, 116.0, 63.0, 2.0, 0.0, 0.0, 11.0, 74.0, 40.0, 101.0, 116.0, 3.0, 33.0, 1.0, 1.0, 11.0, 14.0, 18.0, 116.0, 116.0, 68.0, 12.0, 5.0, 4.0, 2.0, 2.0, 9.0, 102.0, 17.0, 3.0, 10.0, 18.0, 8.0, 15.0, 67.0, 63.0, 15.0, 0.0, 14.0, 116.0, 80.0, 0.0, 2.0, 22.0, 96.0, 37.0, 28.0, 88.0, 43.0, 1.0, 4.0, 18.0, 116.0, 51.0, 5.0, 11.0, 32.0, 14.0, 8.0, 23.0, 44.0, 17.0, 12.0, 9.0, 0.0, 0.0, 19.0, 37.0, 85.0, 18.0, 16.0, 104.0, 22.0, 6.0, 2.0, 26.0, 12.0, 58.0, 67.0, 82.0, 25.0, 12.0, 2.0, 2.0, 25.0, 18.0, 8.0, 2.0, 19.0, 42.0, 48.0, 11.0]) SELECT RAW id FROM b1 WHERE size = 6 AND brand = "nike" ORDER BY ANN(vec, qvec,  "L2_SQUARED",3) LIMIT 100;
      

      Index 100% resident

      It takes 30ms how many times u run

      now kill indexer

      rerun query it takes 300ms how many times you run. (Even normal if you wait quite bit of time or after couple of runs suddenly bumps high time this causes no QPS measurement)

      Attachments

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

        Activity

          People

            sai.teja Sai Krishna Teja
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty