Hi,
There is no specific syntax to retrieve last records of a query without an
ORDER BY, but you can define an index on PROPERTY1, this will speed up the
sorting. Just consider that you cannot use two different indexes, one for
filtering and one for sorting, so you have to choose.
I hope it
I met a querying performance problem while using a SQL like "SELECT FROM
MyClass WHERE Some-condition ORDER BY PROPERTY1 LIMIT 10 SKIP ###" and
ORDER BY consume to much time in my case for lots of records.
without the "ORDER BY " , the results returned very fast but they are the
earliest