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

 Replying to [comment:4 nacin]:
 This sounds like a good idea. Perhaps we can loop 5 times and if there
 aren't 5 non-spam comments, can run a query to select only non-spam
 comments. Primarily this was affecting larger sites with many comments so
 the testing should be done on a comments table with at least few hundred
 thousands rows.

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