select w from x where y > marker order by y limit z This gives you consistent pagination, means the database doesn't have to count matching rows to find an offset, and means you could shard by y later in life if you need to scale that much.
On May 25, 2011, at 2:28 PM, Jay Pipes wrote: > On Wed, May 25, 2011 at 3:10 PM, Greg Holt <gh...@rackspace.com> wrote: >> Okay cool. Just stop using the term offset anywhere in your examples then >> and drop the whole page= thing as well. :) > > Sorry, I'm not understanding what you're getting at here. The offset > is required to pass to the database query as the OFFSET clause. The > page= parameter allows you to calculate that OFFSET value. > > -jay _______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : openstack@lists.launchpad.net Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp
