[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:  Awaiting Review        
Component:  Administration  |     Version:  3.0                    
 Severity:  normal          |    Keywords:  has-patch needs-testing
----------------------------+-----------------------------------------------

Comment(by Viper007Bond):

 I just noticed the inline comment. It looks like this was done on purpose
 for query performance reasons.

 However on WordPress.com we ran into an issue where a blog's most recent
 25000 comments or so were all spam. That means the `while()` had to run a
 few hundred queries before it managed to find enough non-spam comments. I
 would not be surprised if self-hosted blogs ran into this exact same
 issue.

 I think it's better to have a little bit slower query rather than having
 to do potentially many, many queries.

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