Add pagination to browser queries
Some of the browser queries can potentially return a large result set. So add the ability to limit the results to a reasonable number, and add paging through them.
#1 Updated by Robert Illingworth over 5 years ago
- Status changed from New to Assigned
5257e3d adds limit and after_id parameters to the project list query. The latter will return rows where the project_id is greater than the given value; this is more efficient than using offset as the DB can jump over the indexed column rather than having to count through and discard so many rows. Using either of these parameter also add an "order by project_id" clause to the query, so it will return consistent results.