[wp-hackers] Metadata Mess
otto at ottodestruct.com
Tue Dec 22 21:08:59 UTC 2009
On Tue, Dec 22, 2009 at 2:42 PM, Malaiac <malaiac at gmail.com> wrote:
> See, you are focused on portability and one time performance of...
Almost forgot, the "ALTER" is not a one time thing. If you use enums,
then every time you add a new meta type, your table gets altered.
ENUM's are enumerated, meaning that they're pre-defined. You can't add
new ones on the fly, which is sorta the whole point behind meta.
That was what he was talking about. Use of ENUMs is a major
performance drain for most sites (you know, the ones which aren't
using 30 metas on each post and 20k comments on every page).
Sent from Memphis, TN, United States
More information about the wp-hackers