[wp-hackers] suggestions for the next (not immediate)release
dmhouse at gmail.com
Mon Aug 15 15:41:54 GMT 2005
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  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.
-David House, dmhouse at gmail.com, http://xmouse.ithium.net
More information about the wp-hackers