List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:April 6 1999 11:47am
Subject:Re: varchar vs text
View as plain text  
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
Thread
varchar vs textSasha Pachev5 Apr
  • varchar vs textMichael Widenius6 Apr
    • Re: varchar vs textPaul DuBois6 Apr
  • Re: varchar vs textSasha Pachev6 Apr
    • Full text search?Fraser MacKenzie6 Apr
      • Re: Full text search?Thimble Smith6 Apr
        • Re: Full text search?Michael Widenius10 Apr
    • Re: varchar vs textMichael Widenius10 Apr