Log in with username/password: lyceum/lyceum

Changeset 1012

Show
Ignore:
Timestamp:
03/02/07 05:19:22 (3 years ago)
Author:
jjb
Message:

http://lyceum.ibiblio.org/2007/03/02/last-night-a-b-tree-saved-my-life-or-how-to-do-a-simple-index-audit-to-fix-a-slow-query/

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/src/lyceum/wp-admin/upgrade-schema.php

    r1004 r1012  
    9797  category_id int unsigned NOT NULL default '0', 
    9898  PRIMARY KEY  (rel_id), 
    99   KEY post_id (post_id,category_id) 
     99  UNIQUE post_id (post_id,category_id), 
     100   UNIQUE category_id (category_id,post_id) 
    100101) ENGINE = InnoDB; 
    101102CREATE TABLE $wpdb->postmeta ( 
Log in with username/password: lyceum/lyceum