Hi, we recently started with couchbase and n1ql is the best but we have some problem with pagination.
We use couchbase community edition 5 with one bucket and 2.000.000 documents.
This is the problem:
if we run query "SELECT COUNT(*) FROM
bucket" return in 11.83ms, but if we run query “SELECT COUNT(*) FROM
attr_name=1” server response in 17.38s.
All the documents have attr_name equal to 1 and it’s indexed. On production we will have 30.000.000 docs.
Indexes on server :
- "CREATE PRIMARY INDEX
- “CREATE INDEX
How can i reduce the query count time?