homepage Welcome to WebmasterWorld Guest from 23.20.19.131
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Table design
sunroof




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

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




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

BOOLEAN

JerryOdom




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

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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved