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

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.

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

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

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

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

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

would have drastically reduced the number of mysql tables !

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.