We apologize for the instability of composr.app and appreciate your patience. We are working on the statistics addon and trying to find an optimal way to store and render data. Unfortunately, we have yet to find a solution that can handle the traffic (and therefore, tens of millions of statistical records) of composr.app. We're working hard on one.
#3185 - Pagination indexing table specifically for forum topics
We may be able to implement this by wrapping the database layer.
If it can find a pagination index record covering a pagination, it would fall back to regular use of offsets. This is important, as we can't immediately rebuild the index every time a post is added/deleted - we can do it in the background using a Cron hook (which depends on #3958).
It's also important to consider different sort orders and filters that may be active. There may need to be more fields and more indexes for the index table.
We should also try and cache counts for particular paginations.
If it can find a pagination index record covering a pagination, it would fall back to regular use of offsets. This is important, as we can't immediately rebuild the index every time a post is added/deleted - we can do it in the background using a Cron hook (which depends on #3958).
It's also important to consider different sort orders and filters that may be active. There may need to be more fields and more indexes for the index table.
We should also try and cache counts for particular paginations.