[wp-hackers] 2.0.4 Performance Issues

[Ryan Boren]

Brian Layman wrote:
>> Already there.
>>     
> Actually, this is somewhat revealing...
>
> I just created another site from the 2.04 install and it only has the
> PRIMARY and post_name indices/indexes in that DB too.
>
> According to upgrade-schema.php, you are only suppose to have KEY and
> post_name:
> CREATE TABLE $wpdb->posts (
>   [A BUNCH OF FIELDS]
>   PRIMARY KEY  (ID),
>   KEY post_name (post_name)
> );
>
>
> However, in upgrade-functions.php, the 'post_status' index is added as
> part of function upgrade_101().
>   
Good catch.  Maybe we can add the key we've been using in 2.1.

http://trac.wordpress.org/changeset/4076

Ryan