[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 azaozz):

 As far as I remember the performance hit of selecting only non-spam
 comments was quite significant. And this will run on each loading of the
 dashboard, millions of times more often than finding a site where
 thousands of the recent comments are all spam.

 Perhaps we could limit the loop to running only 5-10 times and if there
 aren't enough non-spam comments we can output some kind of notice that all
 the recent comments are in the spam queue.

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