Hi @vsr1 We are looking for some couchbase lookup queries and while getting them from Db, we are getting high response time , though we have added the necessary indexes.Needed your help to fine grain them. WITH pages AS ( SELECT page.pageId, page.allowPastInstance , * FROM b1 AS page WHER…

vsr1 April 23, 2021, 3:54pm 2

N1QL | Query Performance Issue with multiple where clause SQL++

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: …

show post in topic

Home
Categories
FAQ/Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled

Couchbase Queries taking more time