ghostrigger said:
@sequential pagination
don't know if it's a bug but old pagination still works. just append "?page=$pageNo" to the url where $pageNo is the page of interest. tested in anonymous mode.
example: page 10
Intended, I think. Queries having "order:" clauses will be using regular pagination once fixed, anyway, and gold+ use regular pagination. Technically, it's possible to write a userscript that brings back regular pagination.
Anyway, this should probably have been discussed beforehand. Even github commit comment didn't indicate the changes, it was supposed to kill post count queries for pages that don't require paginators like atom feeds or api.
Still, I think it's possible to integrate sequential paginator with regular pagination for queries besides "order:". Most of time people browse pages sequentially. So, if user is for example on page 3, where first post on page is #900000 and last is #800000, then we could add additional parameter to links to page 2 and 4. Link to 2 would be "page=2&spage=a900000" and 4 would be "page=4&spage=b800000". When danbooru encounters such link, it would use page number for display only, and actually use post number to build next page contents. If user decides to browse to page 5, the old-style query happens, but links to page 6 and page 4 will have "spage" argument so queries would be faster.
What this solution doesn't address is that sequential paging gets rid of count query which times out most often, loads the server incredibly and which is used only to get total page count. It is supposed to be cached, but turns out there was a bug and it didn't work at all - see issue #2439. Perhaps it will be easier on the database now that it's fixed and albert will revert changes. Another way is to always assume there's 4 more pages unless precise count is stored. This will cut the load, give back regular pagination, but will result in the possibility of "blank" pages.
tl;dr this needs thorough discussion, please don't start a flamewar beforehand.