mysql@lists.mysql.com
>Subject: RE: efficient use of varchar?
>
>>-Original Message-
>>From: petya [mailto:pe...@petya.org.hu]
>>Sent: Wednesday, April 06, 2011 3:55 PM
>>To: John G. Heim
>>Cc: mysql@lists.mysql.com
>>Subject: Re: efficient use of
>-Original Message-
>From: petya [mailto:pe...@petya.org.hu]
>Sent: Wednesday, April 06, 2011 3:55 PM
>To: John G. Heim
>Cc: mysql@lists.mysql.com
>Subject: Re: efficient use of varchar?
>
>Hi,
>
>There is difference between varchar(63) and varchar(38). In
Hi,
There is difference between varchar(63) and varchar(38). Instead of
selecting MAX(LENGTH()) you can do PROCEDURE ANALYZE() on the table,
which will tell you about the optimal record type for the data you
currently have in the table.
When you are using inreasonably large varchar columns,
Does it make any difference if I allocate a particular number of bytes for a
varchar? I mean, just as an example, maybe its more efficient to use a power
of 2 as the field length. Or maybe power of 2 minus 1. I'm guessing not and
that anything less than 255 is the same.
I'm converting some dat
