| Welcome to WebmasterWorld Guest from 18.104.22.168 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
| 5:25 pm on Jan 5, 2009 (gmt 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)|
| 5:45 pm on Jan 5, 2009 (gmt 0)|
I generally use integer/tinyint in case I change my software requirements down the road.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved