Ask Your Question

Why marker instead of SQL OFFSET in oslo paginate-query?

asked 2013-03-21 08:32:21 -0500

david-kranz gravatar image

Creating a UI that supports page forward/back and seek is not very easy using the marker methodology. I am not a SQL expert by any means, but is there a reason it would be bad to use OFFSET along with LIMIT which would provide a more flexible result?

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2013-03-22 16:35:52 -0500

jaypipes gravatar image

updated 2013-03-24 14:11:31 -0500

smaffulli gravatar image

Hi David,

Here's the thread (from nearly 2 years ago) where Justin Santa Barbara and I discussed the reasons around using marker/limit instead of LIMIT x OFFSET y:

Best, -jay

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools


Asked: 2013-03-21 08:32:21 -0500

Seen: 390 times

Last updated: Mar 24 '13