Welcome to WebmasterWorld Guest from 54.147.0.174

Forum Moderators: open

Message Too Old, No Replies

Table design

     

sunroof

5:25 pm on Jan 5, 2009 (gmt 0)

5+ Year Member



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

5:30 pm on Jan 5, 2009 (gmt 0)

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member



BOOLEAN

JerryOdom

5:45 pm on Jan 5, 2009 (gmt 0)

10+ Year Member



I generally use integer/tinyint in case I change my software requirements down the road.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month