2 Votes Vote

BIT(1) vs ENUM('unknown', 'male', 'female') in MySQL

Posted by topdog 635 days ago Questions| unknown mysql bit All

In performance terms, what will be faster, use a BIT(1) NULL (null = unknown, 0 = male, 1 = female) or ENUM('unknown', 'male', 'female') NOT NULL DEFAULT 'unknown' in MySQL MyISAM?

Or this is considered micro-optimization?

[EDIT]

I think I'm going to use ENUM('male', 'female') DEFAULT NULL

Originally asked by: Wiliam on Stack Overflow

Discuss Bury


Who Voted for this Question