Welcome Guest, Not a member yet? Register   Sign In
Type integer or string: does it matter when querying?
#1

[eluser]codex[/eluser]
Let's say you have a 'color' field in your db, where 'color' represents the color of a (for instance) shoe. You could have brown, black, white. But you could also have the colors be represented by an integer: 1=brown, 2=black, 3=white.

Would it make a difference on performance when you query something like "where color = 'brown'" instead of "where color = 1" '?


Messages In This Thread
Type integer or string: does it matter when querying? - by El Forum - 12-15-2008, 08:39 AM
Type integer or string: does it matter when querying? - by El Forum - 12-15-2008, 09:16 AM
Type integer or string: does it matter when querying? - by El Forum - 12-15-2008, 09:31 AM
Type integer or string: does it matter when querying? - by El Forum - 12-15-2008, 09:37 AM
Type integer or string: does it matter when querying? - by El Forum - 12-15-2008, 12:09 PM
Type integer or string: does it matter when querying? - by El Forum - 12-15-2008, 05:55 PM
Type integer or string: does it matter when querying? - by El Forum - 12-16-2008, 10:32 AM
Type integer or string: does it matter when querying? - by El Forum - 12-16-2008, 11:01 AM
Type integer or string: does it matter when querying? - by El Forum - 12-16-2008, 11:03 AM
Type integer or string: does it matter when querying? - by El Forum - 12-16-2008, 11:11 AM



Theme © iAndrew 2016 - Forum software by © MyBB