[wp-hackers] Metadata Mess

[Otto]

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

-Otto
Sent from Memphis, TN, United States