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

[John Joseph Bachir]

On Thu, 30 Nov 2006, Komra Moriko wrote:

> CREATE INDEX cat_name ON wp_categories (cat_name);
> CREATE INDEX post_date ON wp_posts (post_date);
> CREATE INDEX post_date_gmt ON wp_posts (post_date_gmt);
> CREATE INDEX post_status ON wp_posts (post_status);

Could take another look at this one as well, although i see it was 
recently bumped to 2.2. But it has the potential for making a significant 
difference in some cases.

   http://trac.wordpress.org/ticket/2699

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