[wp-hackers] SELECT SQL_CALC_FOUND_ROWS distinct wp_posts query

[Aaron D. Campbell]

Just as a heads up to anyone else.  That plugin can be really "handy" 
but it creates extremely heavy-handed queries, especially when combined 
with anything else.  Again, it's nice, but it doesn't scale well.  I'm 
hoping to get some time to see if I can clean it up and either pass the 
fixes back to the author or fork the plugin.

Jeremi Bergman wrote:
> Actually, I believe you are right.  I narrowed it down to the *Advanced
> Category Excluder*  plugin.  I've disabled it, and am watching the slow
> query logs.
>
> Thanks
>