On Thu, Jan 24, 2002 at 05:27:18PM -0600, BD wrote: > I will be putting variable length text into a field (up to 255 > characters but typically around 60 characters) and wonder what makes > for faster retrieval? Or does it matter? A field defined as > Varchar(255) or Text?
Do you mean VARCHAR(255) or TINYTEXT? As seen here: http://www.mysql.com/doc/n/o/node_366.html TEXT columns can be much larger than 255. But they require an extra byte for the length portion of the record. So VARCHAR(255) will be ever so slightly faster than TEXT. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 22 days, processed 514,632,289 queries (266/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
