I tested the following with 4.0 and 4.1. N1QL Performance on Order By We are testing N1QL and found a Performance issue when using a order by in the query. I have index on type and lastName. Test Case:* ordering by an attribute (lastName)* paging using skip and limiting to 50 The N1QL query ret…

N1QL vs View Performance Issue

geraldss December 30, 2015, 2:57am 6

It is part of the next major release, codenamed Watson. There will be developer previews of Watson along the way, which will include this fix.

Topic		Replies	Views
Sorting asc vs. desc performance in views and N1QL SQL++	7	3685	May 6, 2014
N1ql does not use index for "order by" SQL++	30	6273	November 4, 2016
Speeding up N1ql queries and indexing as it relates to N1ql SQL++	11	4755	December 12, 2014
N1QL is very slow with "order by" clause SQL++ n1ql	4	2319	September 11, 2016
Very low performance and 100% CPU usage when running simple N1QL query by multiple workers Couchbase Server query , n1ql , server	16	6923	September 15, 2016