[wp-hackers] suggestions for the next (not immediate)release

[David House]

On 11/08/05, Matthew Mullenweg <m at mullenweg.com> wrote:
> There was a thread on this before I believe. MySQL only uses one index
> per query, so adding indicies doesn't always help things. You can test
> out adding an index to every field in the posts table and see if it
> changes the speed any, but in my testing it hasn't.

There are still improvements to be made. Ignoring indices which I know
little to nothing about, I still managed [1] to pick out a few
improvements to the fetch posts query. It's real low-lying fruit here:
simply removing a couple of words is enough for these fixes. The
current SQL is bordering on nonsensical.

[1]: http://lightpress.org/post/wp-queries-a-short-review#235

-- 
-David House, dmhouse at gmail.com, http://xmouse.ithium.net