i put it exactly as it is, but it stopped working after 1000 records... will double check again.
On Fri, Oct 19, 2012 at 3:47 PM, Vasile Ermicioi <elff...@gmail.com> wrote: > _last_id = 0 >> _items_per_page=1000 >> for row in db(db.table.id>_last_id).select(limitby=(0,_items_per_page), >> orderby=db.table.id): >> #do something >> _last_id = row.id > > > you don;t need to change anything to load all data, this code is loading > everything in slices as you need, > all records are ordered by id, and next query will load all next > _items_per_page items > db.table.id>_last_id - will skip all previous records > > -- > > > > --