Couchbase Queries taking more time

[vsr1]

N1QL | Query Performance Issue with multiple where clause

Hello CouchBase Community, The N1QL query is taking more response time when we add a specific where clause. For your understanding, we have two sets of documents (pages and instances). There is one - many relationship between a page and instances. The pageId will be common for a given page and its instances. The WHERE clause mostly revolves around the request time in milliseconds. For each instance document, there is an effective time and expiry time as shown below page { id: 1 pageId: …