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

 +1 to this.  Find it hard to see how an IN (0,1) would be faster than an =
 1 in any event, plus it's best not to transfer the duff data from sql
 server to web server.

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