Hi Dipen, AS I posted on the Couchbase forum, the next release includes this fix for the performance of ORDR BY with LIMIT: http://review.couchbase.org/#/c/57495/
Gerald On Monday, December 28, 2015 at 10:16:48 AM UTC-8, Dipen Patel wrote: > > Hello > > 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 returns the same results over 1.6 - 2.5 seconds > Select r.id, r.fullName FROM my_bucket r > WHERE r.type='user' > Order By r.lastName limit 50 > > Using a view returns back ~700 ms. > > If I remove the order by in the N1QL statement, the results come back > under 100ms > > Thanks. > > > > > -- You received this message because you are subscribed to the Google Groups "Couchbase" group. To unsubscribe from this group and stop receiving emails from it, send an email to couchbase+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.