[wp-hackers] Meta tables: Take 5

[scribu]

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
performance".

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
it?


-- 
http://scribu.net