You can use BENCHMARK to test it. I doubt the difference in speed would be terribly significant, however the longer field will take up more space.
Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Derick Smith" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, 02 June, 2003 12:46 Subject: performance - speed - length of char field Hi! Can anyone tell me if a shorter char field will increase the speed of SELECT queries? (The char field will be indexed). This field is not a varchar. Thanks Eric _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
