Re: Because you guys/gals/girls/women/insert pc term here are a smart lot
| From: | Nathan Rixham | Date: | Tue, 06 Jan 2009 10:55:11 +0000 |
| Subject: | Re: Because you guys/gals/girls/women/insert pc term here are a smart lot | ||
| References: | 1 2 3 4 5 6 7 8 9 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-285504@lists.php.net to get a copy of this message | ||
chris smith wrote:
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 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.