mysql enum performance: is enum slower than INT

Posted by JP19 on Stack Overflow See other posts from Stack Overflow or by JP19
Published on 2010-12-26T08:40:52Z Indexed on 2010/12/26 8:54 UTC
Read the original article Hit count: 124

Filed under:
|

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

© Stack Overflow or respective owner

Related posts about mysql

Related posts about enums