List:MySQL and .NET« Previous MessageNext Message »
From:James Moore Date:December 20 2004 9:38pm
Subject:RE: VACHAR and performance
View as plain text  
AFAIK, the question is whether or not you have any VARCHAR rows in a table.
If you do, you're going to take a performance hit.  I've heard about 25%
slower, but that was back in 3.X, and was specific to MyISAM tables.  Once
you have one, you might as well have several.  (Or, to put it another way,
you should eliminate all VARCHAR columns, depending on your size/speed
tradeoffs.)

 - James
Thread
• utf8Jorge Bastos20 Dec
  • VACHAR and performancePatrick Questembert20 Dec
    • RE: VACHAR and performanceJordan Sparks20 Dec
    • RE: VACHAR and performanceReggie Burnett20 Dec
      • RE: VACHAR and performanceJames Moore20 Dec