Execution time of ORDER BY clause is around 6 seconds. Total docs are just 12K. Couchbase 6.0.0 success | elapsed: 6.81s | execution: 6.81s | count: 10 | size: 4869 { "bktXXX": { "code": "123", "createdAt": 1577177553797, "from": "XXX", "ip": "XXX", "status": 0, …

[image] stuffhold: createAt I think there is typo in ORDER BY. Index key/document field createdAt vs ORDER BY createAt It is not able exploit index order and producing all qualified items for sort.

ORDER BY is slow, have DESC in index

SQL++

stuffhold December 25, 2019, 7:09pm 3

Ohh silly me. Thank you very much for pointing that out.

 success | elapsed: 38.61ms | execution: 38.49ms | count: 10 | size: 4848

Topic		Replies	Views
Order by works very slow SQL++	1	661	February 13, 2019
ORDER_BY ASC on index is much slower than ORDER_BY DESC Couchbase Lite query , n1ql , index	10	1587	October 7, 2019
N1QL Query order by desc is slow SQL++	5	990	January 20, 2021
ORDER BY Performance really slow SQL++	20	6716	December 4, 2017
Index for query with order by SQL++	11	7788	June 25, 2018

ORDER BY is slow, have DESC in index

Related topics