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

[Ryan Boren]

Komra Moriko wrote:
> On WP, out of the box there are some expensive queries that are 
> significantly remedied simply by adding indexes to certain tables. We 
> run one installation under eAccelerator, and one under phpAccelerator. 
> And after the database optimization, I still plan to install a hard page 
> caching scheme, since the queries for paged category archives are the 
> only slow queries that remain. (FWIW, WP-Cache does not behave well in 
> either install.)

What indexes did you add?  We added a few more in 2.1, but if there are 
still more we should add do let us know.

Also, are we talking about 2.0.x or 2.1 here?  We've done some query 
optimization in 2.1, but we could use still more.

Ryan