[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