mysql enum performance: is enum slower than INT
- by JP19
Hi,
Is it better to have a field status enum('active', 'hidden', 'deleted') OR status tinyint(3) with a lookup table. Assume that status can take only one value at a time.
In particular, I am interested in knowing, are operations on enum significantly slower than or as fast as operations on int ?
There is a related question on SO Mysql: enum confusion but
i) It does not discuss performance at all
ii) There is very little explanation on WHY one approach is better than the other.
regards,
JP