June 19, 2013

Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?

… shows MySQL performance when you use 3 different approaches: ENUM, VARCHAR and tinyint (+joined table) columns. In practice you can also often… with ENUM being fastest and VARCHAR few percent slower. This may look counterintuitive because table is significantly smaller with ENUM or TINYINT but…