Db optimization for WP 3.0

[arena]

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`)
)

[Denis-de-Bernardy]

Merging those tables is *NOT* an optimization. Quite the opposite, in fact.

I thought this topic had been closed for good, when we stuck to adding a shared API to access the various meta tables.

Suggesting close as wontfix.

[Denis-de-Bernardy]

It's also nearly guaranteed to break any plugin that might be using the new meta functionality with plugin-defined tables.

[hakre]

Not an enhancement as far as I see. This will create a lot of overhead for no good.

[caesarsgrunt]

This should absolutely be closed as wontfix; it is by no means an optimisation.

[scribu]

Yes, this has been proposed before adding the commentmeta table and it is not the winning solution.

[arena]

even in a WP & WPµ merge (WP 3.0) ?

would have drastically reduced the number of mysql tables !

[dd32]

would have drastically reduced the number of mysql tables !

It would, However MU uses the many tables for a performance reason, and the ability to manage seperately.

The only downside of the many tables approach is that database upgrades can be hard performance-wise, But the modifications taking longer is far outweighed by the extra read-performance IIRC.