[wp-meta] [Making WordPress.org] #3414: Forums pagination breaks at page 100

[Making WordPress.org]

#3414: Forums pagination breaks at page 100
----------------------------+------------------
 Reporter:  davidnaviaweb   |       Owner:
     Type:  defect          |      Status:  new
 Priority:  low             |   Milestone:
Component:  Support Forums  |  Resolution:
 Keywords:                  |
----------------------------+------------------

Comment (by dd32):

 The query time on `all-topics` is shockingly bad, the query time on page
 100 isn't much worse, but given the excessive query time I don't feel
 comfortable recommending the limitation of 99 pages be removed.

 It's so bad that I'd nearly suggest disabling the view entirely until it
 can be fixed.

 Looking closer at the query, it's due to the usage of
 `SQL_CALC_FOUND_ROWS`. If that were removed on larger forums and it just
 assumed that there's 99 pages of results, the query time would be far-far-
 far lower (less than 100ms, where as currently it can be as high as 10s).
 Even with that fixed, the query takes longer on every additional page, 99
 seems like a sane upper limit given the query conditions.

--
Ticket URL: <https://meta.trac.wordpress.org/ticket/3414#comment:5>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org