The following query takes in average 10 seconds to run on a 5 server Cluster vs 22ms in MySQL on the same data set. String retrieveQuery = “SELECT * FROM devalf WHERE phase = '”+ phase + "'AND application = ‘" + application + "’ AND " + “((startTime <=” + startTime + " AND endTime >=" +startTime…

N1QL Queries running slow - how to index?

cihangirb February 1, 2016, 11:57pm 3

Hi Do you have an explain output we can look at?

Topic		Replies	Views
Why executionTime is high? Couchbase Server n1ql	5	846	April 9, 2018
Couchbase server is taking too much time to execute simple n1ql query SQL++	11	3847	December 6, 2017
Very slow query Couchbase Server index	3	901	January 3, 2018
N1QL queries very slow Couchbase Server query , java , n1ql	6	2341	August 25, 2016
N1qL query running too slow on cluster SQL++ query , n1ql , index	1	575	August 4, 2022