we have a test system with 4 nodes all running couchbase server 4.1.
All three services (data, index, query) are running on every node.
When i execute the following query on a bucket with 2.000.000 documents and a secondary index on country,
the query takes about 8 minutes.
SELECT country, COUNT(*) FROM Test GROUP BY country
If i run the same query on our sql server with 20.000.000 entries and no index on country
it takes about 3 minutes.
I haven’t found any statements about the performance of n1ql.
But i think the query should run a lot faster.
Is there a way to speed up the query?