[wp-hackers] Improving WordPress' Performance WAS Changing
John Joseph Bachir
jjb at ibiblio.org
Sat Dec 2 02:26:39 GMT 2006
On Fri, 1 Dec 2006, Chris Williams wrote:
> I assume you mean one index *per table* not one index per query...
> right? Or any join would be painfully slow...
That's correct. Also, if I am not mistaken, I _think_ the limitation was
only one index per WHERE condition. Indexes are still used for GROUP BY
and ORDER BY statements.
And at some point I think even this restriction was lifted? in 5.0? 5.1?
Also, regardless of this, the real payoff is in multi-column indexes. A
multi-colum index tailor-made for a frequent query buys TONS of
More information about the wp-hackers