At 5:46 PM -0500 11/8/01, Tony wrote: >On Thursday 08 November 2001 10:55 am, Paul DuBois wrote: >> At 10:00 AM -0500 11/8/01, Tony wrote: >> >Does anyone know if putting (or grouping) varchar columns at the end of a >> >table provides any performance improvements? My indices are all integers, >> >but not have varchar columns in between several integer columns. >> >> You'll get a speed improvement only if all your columns are fixed length. >> Otherwise the table has variable length rows, no matter the placement >> of the variable length coluumns. >> > >So then is the real purpose of using varchars, to save disk space? ( I >realize this is probably a general database question, just trying to learn).
Right. --------------------------------------------------------------------- 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