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 helps Thanks Luigi 2017-05-23 8:30 GMT+02:00 jkchin <[email protected]>: > 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 records, but I need it return the latest . I'm not using > lightweight edge and index. Is it possible to get the latest results > without ORDER command? > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" 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. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" 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.
