Michael Widenius wrote:
>
> >>>>> "Sasha" == Sasha Pachev <sasha@stripped> writes:
>
> Sasha> Is there any difference in performance between varchar
> Sasha> and text?
>
> Hi!
>
> Yes; VARCHAR is slower.
>
> This is documented in the MySQL manual; Search after 'fixed size
> rows'!
>
> Regards,
> Monty
Monty,
The manual talks about varchar vs char, which obviously favors char
because of fixed length. However, both text and varchar have variable
length, so there seem to be no apparent reason for one to be much faster
than the other.
--
Sasha Pachev
http://www.sashanet.com
