Seek/keyset functionality cancelled?

[chamalis]

Hi, Is there any reasoning behind removing row-number query type in #384 ? Theoretically the seek pagination is way faster than the limit/offset, in Postgresql, due to using the where clause instead the offset e.g: [1]

Am I missing something? Thanks!

[uriyyo]

Hi @chamalis, For such cases, I guess cursor-based pagination will be a better option.

I ran several different benchmarks and implementation from #384 was always much slower rather than limit/offset approach.

[chamalis]

Hi @uriyyo ,

I ran several different benchmarks and implementation from #384 was always much slower rather than limit/offset approach.

Interesting! Thanks