[wp-hackers] Meta tables: Take 5

scribu scribu at gmail.com
Fri Jul 24 21:17:11 UTC 2009

Ok, so it seems pretty clear that separate tables are a bad ideea.

A few questions still remain:

What happens to postmeta and usermeta?

Moving them to the single meta table would involve:
- reformating hardcoded sql in Core
- redoing the bbPress integration

Another thing that was proposed is that each meta type in the single meta
table should be stored in a separate table.

By the same principle, we should also move meta_keys to separate tables.
Where would that get us?

On the one hand, creating separate tables for each meta type "adds
complexity", but moving a single column to a separate table "might enhance

Since almost every query for meta data requires the meta type, a JOIN would
almost always be involved. Wouldn't that hurt performance more than enhance


More information about the wp-hackers mailing list