Details
-
Bug
-
Resolution: Unresolved
-
Major
-
Cypher
-
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)