Nathan Rixham wrote:
chris smith wrote:
It may be worth mentioning that, IIRC, CHAR is faster due to the fixed
length. If you can make your table use a fixed length row size (ie no
variable length columns), it'll be faster.
I'd be interested in seeing tests about this.. I doubt there's any
difference.
quote: http://dev.mysql.com/doc/refman/5.1/en/data-size.html
For MyISAM tables, if you do not have any variable-length columns
(VARCHAR, TEXT, or BLOB columns), a fixed-size row format is used. *This
is faster but unfortunately may waste some space.* See Section 13.4.3,
“MyISAM Table Storage Formats”. You can hint that you want to have fixed
length rows even if you have VARCHAR columns with the CREATE TABLE
option ROW_FORMAT=FIXED.
It'd still be interesting to see if it made any noticeable difference
(I'm guessing not until you get into rather large db's).
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
