[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:  Future
Component:  Administration                       |  Release
 Severity:  normal                               |     Version:  3.0
 Keywords:  has-patch needs-refresh dev-         |  Resolution:
  feedback                                       |
-------------------------------------------------+-------------------------

Comment (by chmac):

 I just hit this problem on a self hosted site with >30k spam comments. We
 get a lot of spam volume, and hitting the dashboard admin was putting PHP
 into a near-perpetual loop looking for enough comments. Very, very, very
 bad for the server. Somehow PHP was getting around the 30 second max
 execution time and so after hitting the page a few times, the whole server
 ground to a halt. :-(

 Having just read the history (briefly), unless there's a major performance
 hit to put != spam into the query, I think that makes the most sense.

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