[wp-trac] [WordPress Trac] #16321: Unmoderated comments cause dashboard to break

[WordPress Trac]

#16321: Unmoderated comments cause dashboard to break
--------------------------+------------------------------
 Reporter:  brianfreytag  |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  General       |     Version:
 Severity:  normal        |  Resolution:
 Keywords:  close         |
--------------------------+------------------------------

Comment (by nacin):

 Yes, I get that. What I'm saying is that the problem is likely the same as
 #14222. We go into a while() loop to fetch comments, and then exclude the
 spam comments in PHP.

 Taking a long time to load can lead into not loading at all, if memory is
 exhausted. With enough comments, that would happen.

 Can you try out
 http://core.trac.wordpress.org/attachment/ticket/14222/14222.2.patch and
 see how it goes? Maybe just execute the SQL against the database and see
 how long it takes (and please tell us the number of rows in that table,
 and how many are spam) -- it'd look like this:

 SELECT * FROM wp_comments c LEFT JOIN wp_posts p ON c.comment_post_ID =
 p.ID WHERE c.comment_approved IN (0,1) AND p.post_status != 'trash' ORDER
 BY c.comment_date_gmt DESC LIMIT 0, 50

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/16321#comment:3>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software