Currently using DP 4.5
Using 3 VMs each running 4cores/4gb ram and each running different service(data, index, query) all in a 7200rpm drive. Currently I have 1M test data on it. I want to know if this is an acceptable result from n1ql testing.
default(ARRAY d.tags FOR d IN default END)
SELECT meta().id as
Key FROM default WHERE meta().id LIKE ‘Application_%’ AND ANY tag IN tags SATISFIES tag IN[‘tag1’, ‘tag9’] END
ran this 10x and its a consistent with the data below
Time elapsed: 32865 ms
Result Row(s): 166666
Another question is I want this query to be faster than 32000ms. Should I add another box of index, query, or data? I tried adding more cpus to the query service and it didnt helped speeding it up.