Many years ago, I recall being told that you should choose Text Field Sizes in certain increments for performance, but I don’t remember the formula to use… :-/
It had something to do with matching the Field Size with how the Database stores things on the back end, and was multiples of something…
So, as far as MySQL and VARCHAR() goes, is there such a formula?
For example, would VARCHAR(64) be better than VARCHAR(59) of VARCHAR(65)?
if you don’t really care, make all of them VARCHAR(255)
if you do care, i.e. you want the system to tell you when it has truncated an input string to make it fit within the maximum of 64 or 59 or whatever you need, then yes, tailor it to the exact maximum you need
look for the stackoverflow pages that contain a discussion on what happens when a result set is built (e.g. when sorting is required)
took me less than 30 seconds to find that there might be a performance issue if you have a VARCHAR defined too big and the result set returns many many rows
for small result sets i don’t think it makes a difference