Improve SQL pagination #210
Description
Another small implementation issue relates to pagination. Right now, using limit/offset paging is probably fine, but after you get to result sets in the many thousands range, you may find that your database is taking a hit if you allow very large offset values. You may want to consider a cursor-based pagination approach for offsets larger than, say, 5000 or so. The cutoff largely depends on your database load and the time you want to allow for queries to complete.
I probably should have opened a new issue on this one, but I'll leave the comment here and leave it up to you all....