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 [email protected]. For more options, visit https://groups.google.com/d/optout.
