| Welcome to WebmasterWorld Guest from 188.8.131.52 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
| 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 ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved