[wp-trac] [WordPress Trac] #11914: "Users" admin list slow to generate on large sites
WordPress Trac
wp-trac at lists.automattic.com
Fri Jan 15 19:43:39 UTC 2010
#11914: "Users" admin list slow to generate on large sites
--------------------------+-------------------------------------------------
Reporter: rowanbeentje | Owner:
Type: defect (bug) | Status: new
Priority: low | Milestone: Future Release
Component: Optimization | Version: 2.9.1
Severity: minor | Keywords: users mysql slow query
--------------------------+-------------------------------------------------
Comment(by rowanbeentje):
On this table, the slow part of the query is the post_author part - seen
when adding an index on post_author makes the query 5x-10x faster; so I
think it's slightly different from #11375.
SQL injection vuln probably isn't too bad on get_private_posts_cap_sql as
it's using hardcoded inputs, but always worth fixing to avoid future
issues…!
--
Ticket URL: <http://core.trac.wordpress.org/ticket/11914#comment:8>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software
More information about the wp-trac
mailing list