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
|
Don Mosney -
Front End Web Developer
|
282.997493
|
#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
|
Don Mosney -
Front End Web Developer
|
1032.35993
|
#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.