[wp-trac] [WordPress Trac] #14222: Improve dashboard recent comments widget performance by not fetching spam comments

[WordPress Trac]

#14222: Improve dashboard recent comments widget performance by not fetching spam
comments
------------------------------+------------------
 Reporter:  Viper007Bond      |       Owner:
     Type:  defect (bug)      |      Status:  new
 Priority:  normal            |   Milestone:  3.2
Component:  Administration    |     Version:  3.0
 Severity:  normal            |  Resolution:
 Keywords:  has-patch commit  |
------------------------------+------------------

Comment (by markkelnar):

 I've tested the 2.patch on a site with 25k+ spam comments.  It pans down
 the number of sql queries to get the 5 most recent allowed comments from
 500 to 1.

 I agree that the most efficient way to filter out spam comments is to have
 the comment_approved state in the database query instead of post
 processing that in PHP.

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