[wp-hackers] Meta tables: Take 5
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