hi, There are a total of 15,304 documents on the bucket. I query through these documents, but they respond very slowly. I added indexes but nothing changed. query: select id from PiriWiki USE INDEX (ademtest USING GSI) where type='Timeline’ and templateId='template-timeline’ and pageId = ‘20…

Very slow query

vsr1 December 29, 2017, 3:47pm 2

Use following index
CREATE INDEX tes1 ON PiriWiki(templateId, languageId, isApproved, pageId,id) WHERE type = "Timeline"

Topic		Replies	Views
Couchbase query execution taking too much time SQL++ query	4	983	December 20, 2018
Very poor performance on a simple structure Couchbase Server	2	801	December 2, 2019
Query slow in a bucket which is having only 800 records SQL++	12	2850	July 16, 2018
N1QL Queries running slow - how to index? Couchbase Server	2	2589	February 1, 2016
Couchbase count query is so slow SQL++ query	26	3168	December 24, 2018