wiki:ServerSidePagination

Version 5 (modified by Fran Boon, 12 years ago) ( diff )

--

Server-Side Pagination

Currently we do all pagination client-side which won't be possible to keep doing as we accumulate more data

This will be needed for:

fractalis has offered to look at this

Will need to patch into the models\01_RESTlike_Controller.

We already have options to filter the results within a busy REST controller, so could do something like:

if request.vars.page and request.vars.pagesize:
    start = (request.vars.page - 1) * request.vars.pagesize
    stop = request.vars.page * request.vars.pagesize
    response.s3.filter = (db['%s_%s' % (module, resource)].id > 0).select(limitby=(start, stop))

Maybe look at the currently-unused modules/webgrid.py.


Haiti

Note: See TracWiki for help on using the wiki.