Closed Pagination optimization

[Deleted member 232995]

Affected version

2.x

I have experienced in everyday life with very large forums (hundreds of thousands of threads in a node) or even 100 thousand entries in the RM. that the pagination is very very slow. It seems to be an OFFSETT problem.

Sure - now you could argue about who already clicks on page XXXXXXXX. But just because few do it doesn't make this problem better.
Especially since Crawler belongs to those who go through all pages.
Which is not only bad for my resources but also for the rating of the crawler.

 

[XF Bug Bot]

Automated triage: Design issue

Thank you for reporting this issue. Pages are fetched by skipping all the rows before the requested page, so very deep pages in very large lists do cost more to load. That is how pagination is currently built, not a fault in it. Changing it would be a design change, not a bug fix. Limiting a forum's thread list by date reduces how deep the pages can go.

This is an automated assessment. A member of staff may review and update it.