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

[Ryan Boren]

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.
> 
>   http://trac.wordpress.org/ticket/2699

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?

Ryan