Thanks for that, Steven :) So just to clarify, results are ordered by the relevant timestamps to ensure consistent order and so that new records would never show on previous "pages" and be missed, and we're limited to just a "next page" navigation, and we cannot order the entire result set on any column but the timestamps, as this would break the paging because we can't do the comparisons we need to if the results aren't in that order. Have I got that correct?
Thanks, Mike ________________________________ From: Steven Kaufer [kau...@us.ibm.com] Sent: 03 November 2014 22:39 To: OpenStack Development Mailing List (not for usage questions) Subject: Re: [openstack-dev] [oslo.db] Marker based paging Here are a few ML threads on this topic: http://lists.openstack.org/pipermail/openstack-dev/2014-March/030322.html http://www.gossamer-threads.com/lists/openstack/dev/2777 http://lists.openstack.org/pipermail/openstack-dev/2013-November/018861.html Thanks, Steven Kaufer Roman Podoliaka <rpodoly...@mirantis.com> wrote on 11/03/2014 10:35:21 AM: > From: Roman Podoliaka <rpodoly...@mirantis.com> > To: "OpenStack Development Mailing List (not for usage questions)" > <openstack-dev@lists.openstack.org> > Date: 11/03/2014 10:43 AM > Subject: Re: [openstack-dev] [oslo.db] Marker based paging > > Hi Mike, > > I think that code was taken from Nova (or maybe some other project) as > is and we haven't touched it since then. > > Please speak up - we want to know about all possible problems with > current approach. > > Thanks, > Roman > > On Fri, Oct 31, 2014 at 2:58 PM, Heald, Mike <mike.he...@hp.com> wrote: > > Hi all, > > > > I'm implementing paging on storyboard, and I wanted to ask why we > decided to use marker based paging. I have some opinions on this, > but I want to keep my mouth shut until I find out what problem it > was solving :) > > > > Thanks, > > Mike > > > > > > _______________________________________________ > > OpenStack-dev mailing list > > OpenStack-dev@lists.openstack.org > > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > > _______________________________________________ > OpenStack-dev mailing list > OpenStack-dev@lists.openstack.org > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > _______________________________________________ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
