[wp-meta] [Making WordPress.org] #6455: the /view/all-topics view is frequently failing

[Making WordPress.org]

#6455: the /view/all-topics view is frequently failing
----------------------------+---------------------
 Reporter:  sterndata       |       Owner:  dd32
     Type:  defect (bug)    |      Status:  closed
 Priority:  high            |   Milestone:
Component:  Support Forums  |  Resolution:  fixed
 Keywords:                  |
----------------------------+---------------------

Comment (by dd32):

 Realised we already had code to limit the `all-replies` view to posts in
 the last month, limiting the `all-topics` to the last-month for
 WordPress.org/support (NOT for localised forums) provides the significant
 performance boost needed here - with the query being sub-1s.


 The query explain shows it's still scanning a bunch of rows, but it's not
 anywhere near as bad anymore. The query effectively just includes an
 additional `AND ( wporg_419_posts.ID >= %d )`
 {{{
 id      select_type     table           type    possible_keys
 key     key_len ref     rows    Extra
 1       SIMPLE          wp_posts        range
 PRIMARY,type_status_date,post_parent    PRIMARY 8       NULL    187840
 Using where
 }}}

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