Paging doesnt work with @rid > lower rid

[Suyog Kale]

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.

[alessand...@gmail.com]

Hi,

could you explain better, what you want to achieve?

Thanks