I have this index CREATE INDEX `test_field1_field2_index` ON `qtest`.`qscope`.`qcoll`(`field1`,`field2`); And I want to execute these 2 query, but they take too much time. Can you help me about this. You can find query, explain and information from system:completed_requests below. Query1 selec…

Why my count queries are slow?

system Closed November 21, 2023, 12:24pm 10

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Simple count(*) query takes 2+ seconds SQL++	51	18267	May 30, 2017
Couchbase count query is so slow SQL++ query	26	3168	December 24, 2018
Count is taking long time SQL++ query , n1ql	19	5422	March 29, 2016
Query on Index fields are running slow SQL++ index	33	3163	January 25, 2019
N1QL: Count query sometimes slow, sometimes not with different possible indexes Couchbase Server n1ql	10	1753	November 9, 2017