[wp-trac] [WordPress Trac] #48514: Performance issue in COUNT query pluggable.php

[WordPress Trac]

#48514: Performance issue in COUNT query pluggable.php
-------------------------+-----------------------------
 Reporter:  sgoen        |       Owner:  SergeyBiryukov
     Type:  enhancement  |      Status:  closed
 Priority:  normal       |   Milestone:  5.4
Component:  Comments     |     Version:  5.3
 Severity:  normal       |  Resolution:  fixed
 Keywords:               |     Focuses:  performance
-------------------------+-----------------------------
Changes (by SergeyBiryukov):

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


Comment:

 In [changeset:"46878" 46878]:
 {{{
 #!CommitTicketReference repository="" revision="46878"
 Comments: Optimize the query for pending comments count in
 `wp_notify_moderator()` for better performance on large tables.

 Props sgoen.
 Fixes #48514.
 }}}

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