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? It is unlikely this field will be used for searching and it will not be indexed. This table will be part of a web application so a lot of people will be doing queries on the table and this field will be displayed as a grid field in the browser. The user queries will only return10-100 records at a time but there will be a lot of simultaneous connections to the database.
Any opinions on which is better? VarChar(255) or Text? TIA Brent --------------------------------------------------------------------- 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