|
Posted by ZeldorBlat on 09/21/06 14:05
The Eclectic Electric wrote:
> 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
Here's an excellent article on the subject:
<http://www.google.com/search?q=char+versus+varchar>
Navigation:
[Reply to this message]
|