[wp-hackers] Improving WordPress' Performance WAS Changing MySQL
ryan at boren.nu
Fri Dec 1 00:40:39 GMT 2006
John Joseph Bachir wrote:
> 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.
The get/set option API enforces unique option names, I believe, but I've
seen some databases that had duplicate keys nonetheless. What happens
when we make the key unique but have dupe names in the DB?
More information about the wp-hackers