[wp-meta] [Making WordPress.org] #7624: In support forum , Page navigation issue

[Making WordPress.org]

#7624: In support forum , Page navigation issue
-----------------------------+---------------------
 Reporter:  pranitdugad      |       Owner:  (none)
     Type:  defect (bug)     |      Status:  new
 Priority:  lowest           |   Milestone:
Component:  Support Forums   |  Resolution:
 Keywords:  has-screenshots  |
-----------------------------+---------------------
Changes (by dd32):

 * priority:  low => lowest


Comment:

 This is caused by inefficiencies of bbPress at the scale of the WordPress
 forums.

 https://meta.trac.wordpress.org/browser/sites/trunk/wordpress.org/public_html
 /wp-content/plugins/support-forums/inc/class-performance-
 optimizations.php?rev=13539&marks=288-293,369-393#L287

 For example; For the OP, the number of topics is `22825` (761 pages), but
 according to the `_bbp_topic_count` meta_value it's `22942` (765 pages),
 and if I enable my moderation powers it's `22977` (766 pages).

 If someone had a pending post in the forum they might have `1` or `2` more
 threads than someone else.

 The only real way to calculate the correct number of pages for a given
 user is to query for all the matching threads, but that takes a SQL of
 several seconds, which isn't viable.

 It does seem that `_bbp_topic_count` is ''probably'' incorrect for the
 forum, as it's close but not exactly the same as the other values.

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