Posted by The Eclectic Electric on 09/21/06 11:40
From a performance perspective, assuming my table might grow to a sizeable
number of entries, is it better to use VARCHAR or CHAR? Intitution says
that CHAR would obviously be faster to search through, but if I'm not using
the VARCHAR element in a WHERE clause then it's probably better to use
VARCHAR since it keeps the size of the table down and therefore more likely
to be in memory? Is this correct?
+e
[Back to original message]
|