[wp-trac] Re: [WordPress Trac] #7415: "using filesort" in default
install
WordPress Trac
wp-trac at lists.automattic.com
Sat Feb 14 07:58:25 GMT 2009
#7415: "using filesort" in default install
--------------------------+-------------------------------------------------
Reporter: dbuser123 | Owner: anonymous
Type: defect (bug) | Status: new
Priority: high | Milestone: 2.8
Component: Optimization | Version: 2.7
Severity: major | Keywords: database, optimization, slow queries, filesort
--------------------------+-------------------------------------------------
Comment(by rawalex):
If you need the data and the count, why not just do the query and then a
mysql_count_rows? If you are just looking for the count, then severely
limit the fields you are pulling in (wp_post.* is a bad choice if you
don't need the data). Less fields means less data space required.
--
Ticket URL: <http://core.trac.wordpress.org/ticket/7415#comment:29>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software
More information about the wp-trac
mailing list