[wp-trac] [WordPress Trac] #14222: Improve dashboard recent comments widget performance by not fetching spam comments
WordPress Trac
wp-trac at lists.automattic.com
Thu May 19 18:22:36 UTC 2011
#14222: Improve dashboard recent comments widget performance by not fetching spam
comments
------------------------------+------------------
Reporter: Viper007Bond | Owner:
Type: defect (bug) | Status: new
Priority: normal | Milestone: 3.2
Component: Administration | Version: 3.0
Severity: normal | Resolution:
Keywords: has-patch commit |
------------------------------+------------------
Comment (by markkelnar):
I've tested the 2.patch on a site with 25k+ spam comments. It pans down
the number of sql queries to get the 5 most recent allowed comments from
500 to 1.
I agree that the most efficient way to filter out spam comments is to have
the comment_approved state in the database query instead of post
processing that in PHP.
--
Ticket URL: <http://core.trac.wordpress.org/ticket/14222#comment:13>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software
More information about the wp-trac
mailing list