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

Comment (by nacin):

 Okay. It dawned on me. We never needed the join to begin with. When a post
 gets trashed, it gets assigned a post-trashed status to specifically avoid
 the need to do queries like these.

 I suggest we drop the join, then add in the comment_status changes. Going
 to drop the join now and then do some further testing.

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