From: Johan De Meersman (vegivamptuxera.be)
Date: Wed Jan 07 2009 - 07:34:55 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Wed, Jan 7, 2009 at 2:26 PM, Richard Heyes <richardphp.net> wrote:

> I still think a CHAR field would be faster than a VARCHAR because of
> the fixed row length (assuming every thing else is fixed). Perhaps
> someone from the MySQL list could clarify...?

Say that your column length goes up to 2000 bytes, but on average is less
than 512 bytes (ie. one disk block). What would be faster, reading 1 disk
block (varchar), or reading 4 disk blocks (char) ?

>
>
> --
> Richard Heyes
>
> HTML5 Graphing for FF, Chrome, Opera and Safari:
> http://www.rgraph.org (Updated January 4th)
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=vegivamptuxera.be
>
>

--
Celsius is based on water temperature.
Fahrenheit is based on alcohol temperature.
Ergo, Fahrenheit is better than Celsius. QED.

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]