Changeset 46878

Timestamp:

12/10/2019 01:45:41 PM (5 years ago)

Author:

SergeyBiryukov

Message:

Comments: Optimize the query for pending comments count in wp_notify_moderator() for better performance on large tables.

Props sgoen.
Fixes #48514.

File:

• trunk/src/wp-includes/pluggable.php (modified) (1 diff)

trunk/src/wp-includes/pluggable.php

@@ -1740 +1740 @@
         }
 
-        $comments_waiting = $wpdb->get_var( "SELECT count(comment_ID) FROM $wpdb->comments WHERE comment_approved = '0'" );
+        $comments_waiting = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '0'" );
 
         // The blogname option is escaped with esc_html on the way into the database in sanitize_option