Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Table design



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

5+ Year Member


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?



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

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



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