[wp-trac] [WordPress Trac] #11500: Db optimization for WP 3.0

WordPress Trac wp-trac at lists.automattic.com
Sat Dec 19 12:35:45 UTC 2009


#11500: Db optimization for WP 3.0
-------------------------+--------------------------------------------------
 Reporter:  arena        |       Owner:  ryan
     Type:  enhancement  |      Status:  new 
 Priority:  normal       |   Milestone:  3.0 
Component:  Database     |     Version:  2.9 
 Severity:  normal       |    Keywords:      
-------------------------+--------------------------------------------------
 Merging all meta tables (post, user, comment) into one :


 {{{
 CREATE TABLE `wp_metas` (
   `id`              bigint(20)     unsigned NOT NULL auto_increment,
   `blog_id`         int(11)        NOT NULL default '0',
   `object_type`     varchar(64)    NOT NULL default '',  /* 'post',
 'comment', 'user', .... */
   `object_id`       bigint(20)     unsigned NOT NULL default '0',
   `key`             varchar(255)   default NULL,
   `value`           longtext,
   PRIMARY KEY  (`id`),
   KEY `object` (`blog_id`, `object_type`, `object_id`),
   KEY `key` (`blog_id`, `object_type`, `object_id`, `key`)
 )
 }}}

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/11500>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list