[wp-hackers] SELECT SQL_CALC_FOUND_ROWS distinct wp_posts query

[Jerry Johnson]

Jeremi,

We are having the same problem.

One of our senior devs did this, which has helped greatly:

http://core.trac.wordpress.org/ticket/10964

Jerry Johnson
Senior Application Developer
*Dolan Media Company* (NYSE:DM)
612.659.7363 :: 612.718.8781 (m)
jerry.johnson [at] dolanmedia [dot] com

On Fri, Oct 16, 2009 at 12:44 PM, Jeremi Bergman <jeremib at gmail.com> wrote:

> It seems there's this one query,
> SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM wp_posts LEFT JOIN
> wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)



> <snip>
>


> Any thoughts on how I can optimize this query?  It takes approx 13 seconds
> to execute this query. I have 28k records.
>
>