Re: Because you guys/gals/girls/women/insert pc term here are a smart lot
| From: | David Giragosian | Date: | Wed, 07 Jan 2009 14:17:25 +0000 |
| Subject: | Re: Because you guys/gals/girls/women/insert pc term here are a smart lot | ||
| References: | 1 2 3 4 5 6 7 8 9 10 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-285557@lists.php.net to get a copy of this message | ||
On 1/7/09, Jim Lyons <jlyons4435@gmail.com> wrote:
>
> There are other factors. If a table is completely fixed in size it makes
> for a faster lookup time since the offset is easier to compute. This is
> true, at least, for myisam tables. All books on tuning that I have read
> have said the CHAR makes for more efficient lookup and comparison that
> VARCHAR.
>
> Also, I was told by the instructor at a MySQL class that all VARCHAR
> columns
> are converted to CHAR when stored in memory. Can anyone else confirm this?
That's my recollection, also, derived from a MySQL class. IIRC, the char
length is equal to the longest varchar record in the column.
David