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.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
