| Table design
|
sunroof
msg:3819604 | 5:25 pm on Jan 5, 2009 (gmt 0) |
Hello, If I have a lot of fields with values 0/1 in my mysql table which I use for filtering data by that field (ie. WHERE field=1...) What is the best type for that field for fastest performance?
enum ('0','1') or tinyint? Thanks
|
coopster
msg:3819619 | 5:30 pm on Jan 5, 2009 (gmt 0) |
BOOLEAN
|
JerryOdom
msg:3819638 | 5:45 pm on Jan 5, 2009 (gmt 0) |
I generally use integer/tinyint in case I change my software requirements down the road.
|
|
|
