Changeset 10079

Timestamp:

12/05/2008 11:42:06 PM (17 years ago)

Author:

ryan

Message:

Speed up Recent Comments dash module query

File:

• trunk/wp-admin/includes/dashboard.php (modified) (2 diffs)

trunk/wp-admin/includes/dashboard.php

@@ -397 +397 @@
  */
 function wp_dashboard_recent_comments() {
-    $status = ( current_user_can('edit_posts') ) ? '' : 'approved';
-
-    list($comments, $total) = _wp_get_comment_list( $status, false, 0, 5 );
+    global $wpdb;
+
+    if ( current_user_can('edit_posts') )
+        $allowed_states = array('0', '1');
+    else
+        $allowed_states = array('1');
+
+    // Select all comment types and filter out spam later for better query performance.
+    $comments = $wpdb->get_results( "SELECT * FROM $wpdb->comments ORDER BY comment_date_gmt DESC LIMIT 0, 50" );
 
     if ( $comments ) :
@@ -406 +412 @@
         <div id="the-comment-list" class="list:comment">
 <?php
-        foreach ( $comments as $comment )
-            _wp_dashboard_recent_comments_row( $comment );
+        foreach ( $comments as $comment ) {
+            if ( in_array($comment->comment_approved, $allowed_states) )
+                _wp_dashboard_recent_comments_row( $comment );
+        }
 ?>