[wp-trac] [WordPress Trac] #19901: Speeding up Dashboard and Comment moderation SQL load

[WordPress Trac]

#19901: Speeding up Dashboard and Comment moderation SQL load
-------------------------------------------------+-------------------------
 Reporter:  FolioVision                          |       Owner:
                                                 |  spacedmonkey
     Type:  enhancement                          |      Status:  reopened
 Priority:  normal                               |   Milestone:  6.0
Component:  Comments                             |     Version:  3.3
 Severity:  major                                |  Resolution:
 Keywords:  needs-testing has-patch commit       |     Focuses:
  assigned-for-commit                            |  performance
-------------------------------------------------+-------------------------
Changes (by peterwilsoncc):

 * status:  closed => reopened
 * resolution:  fixed =>


Comment:

 @spacedmonkey Reopening this because I realised the docblock needs
 updating:

 * remove reference to always using live count
 * remove wpdb global (from docblock and within function)

 ----

 Also does `wp_count_comments()` still need a cache or should a follow up
 be created to remove it in 6.1 now that `get_comment_count()` caches via
 the comment query?

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/19901#comment:38>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform