Hi All, I've built a survey application in MySQL that allows people to enter free-form comments. In processing the input, if the comments string is less than 256 characters long, I save it to a varchar column; if longer, I use a mediumtext.
This works fine, but I'm wondering if I'm getting any real value from it. Is it inherently faster to retrieve varchars than mediumtext, even if the mediumtext is holding small (<256 characters) values? What about for searching on these field types? -Derek --------------------------------------------------------------------- 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
