[wp-hackers] 2.0.4 Performance Issues
ryan at boren.nu
Mon Aug 7 00:33:59 GMT 2006
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
> 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.
More information about the wp-hackers