[wp-hackers] Improving WordPress' Performance WAS Changing MySQLminimum version

[John Joseph Bachir]

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 
performance.

http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html


John
----
aim/yim/msn/jabber.org: johnjosephbachir
713.494.2704
irc://irc.freenode.net/lyceum
http://lyceum.ibiblio.org/
http://blog.johnjosephbachir.org/