Is there a performance advantage to using enum in situations where there are only 5-10 different possible values for a field? if not what is the advantage?
There is a huge performance penalty to using ENUM for operations such as:
ENUM
Query the list of permitted values in the ENUM, for instance to populate a drop-down menu. You have to query the data type from INFORMATION_SCHEMA, and parse the list out of a BLOB field returned.
INFORMATION_SCHEMA
Alter the set of permitted values. It requires an ALTER TABLE statement, which locks the table and may do a restructure.
ALTER TABLE
I'm not a fan of MySQL's ENUM. I prefer to use lookup tables. See also my answer to "How to handle enumerations without enum fields in a database?"
1.4m articles
1.4m replys
5 comments
56.9k users