[OpenStack-Infra] [storyboard] Paging results
    Heald, Mike 
    mike.heald at hp.com
       
    Thu Nov 20 15:45:26 UTC 2014
    
    
  
> @Michael - I suggest just using a simple stable batch marker - e.g.
> the unique key of the edge of the batch - which is stable enough to
> handle inserts and deletes without double-showing or skipping rows.
It can handle inserts and deletes, but it's not stable if you order by a column such as status, or updated time, or, assignee... because those values might change as you browse, and so records would jump around pages. And if the record you're using as a marker changes position in the list, you could be thrown way forward or backward without knowing it.
Mike
    
    
More information about the OpenStack-Infra
mailing list