[wp-hackers] Improving WordPress' Performance WAS Changing MySQL
ryan at boren.nu
Thu Nov 30 20:02:30 GMT 2006
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.
More information about the wp-hackers