Welcome Guest, Not a member yet? Register   Sign In
MySQL: enum vs. int, enum vs. varchar
#1

[eluser]Peter Dräxler[/eluser]
Hi guys.

Which of MySQL columns enum or int is faster if I store only numbers 0 or 1?
Which of MySQL columns enum or varchar is faster if I store only strings TRUE or FALSE?

Thank's
#2

[eluser]danmontgomery[/eluser]
All things being equal, storing and retrieving a number is always faster.
#3

[eluser]Peter Dräxler[/eluser]
Thank's for reply but I'm sorry, I was posted bad questions. Please reply again.
#4

[eluser]danmontgomery[/eluser]
1) tinyint
2) never do this
#5

[eluser]Peter Dräxler[/eluser]
Thank's :-)




Theme © iAndrew 2016 - Forum software by © MyBB