Hello Luca, I have tried implementing paging with @rid > lower rid but if I provide @rid > lower rid then results are in consistent.
*example:* page 1 records with pagesize 2 *select from records where @rid > #-1:-1 limit 2* *endtime* *@rid* *title* 1032.35993 #24:5 <http://104.197.157.182:2480/studio/index.html#/database/KloojjAppDev/browse/edit/24:5> Don Mosney - Front End Web Developer 282.997493 #24:4 <http://104.197.157.182:2480/studio/index.html#/database/KloojjAppDev/browse/edit/24:4> Don Mosney - Front End Web Developer page 2 record with pagesize 1 *select from records where @rid > #24:4 limit 2* *endtime* *@rid* *title* 1200.897216 #24:6 <http://104.197.157.182:2480/studio/index.html#/database/KloojjAppDev/browse/edit/24:6> Don Mosney - Front End Web Developer 1032.35993 *#24:5* <http://104.197.157.182:2480/studio/index.html#/database/KloojjAppDev/browse/edit/24:5> Don Mosney - Front End Web Developer *In this case you can observe that #24:5 is repeated, I can not use sort by because I have to sort a list by endtime. for time being i am using SKIP LIMIT approach but that is slower as compare to using @rid.* *Please suggest better solution. Thank you.* -- --- 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.
