Ask Your Question
0

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
2

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:

http://lists.launchpad.net/openstack/msg02548.html

Best, -jay

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

Stats

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

Seen: 274 times

Last updated: Mar 24 '13