[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:  nacin
     Type:  defect (bug)              |      Status:  closed
 Priority:  normal                    |   Milestone:  3.4
Component:  Performance               |     Version:  3.0
 Severity:  normal                    |  Resolution:  fixed
 Keywords:  has-patch commit already  |
--------------------------------------+---------------------
Changes (by nacin):

 * owner:   => nacin
 * status:  new => closed
 * resolution:   => fixed


Comment:

 In [20609]:
 {{{
 #!CommitTicketReference repository="" revision="20609"
 Make the Recent Comments dashboard widget more performant on sites with
 large amounts of comments, in particular with a heavy spam ratio.

 Simplifies the query by avoiding a join, and leverages the API now rather
 than a direct query.

 fixes #14222.
 }}}

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