Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Table design

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

Junior Member

10+ Year Member

joined:Nov 8, 2005
votes: 0


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

joined:July 31, 2003
votes: 2

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

Preferred Member

10+ Year Member

joined:Sept 9, 2004
votes: 0

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

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members