List:General Discussion« Previous MessageNext Message »
From:Ow Mun Heng Date:September 27 2005 2:39am
Subject:varchar vs char speed improvement
View as plain text  
Is there any doc looking at benchmarks of a database which is populated
entirely with fixed length char compared to variable character lengths?

I know using char is preferred over varchar when it comes to speed. Is
there any available benchmarks available?

Pointers where would be appreciated.

-- 
Ow Mun Heng
Gentoo/Linux on DELL D600 1.4Ghz 1.5GB RAM
98% Microsoft(tm) Free!! 
Neuromancer 10:38:25 up 2 days, 15:24, 6 users, load average: 0.71,
0.56, 0.35 


Thread
varchar vs char speed improvementOw Mun Heng27 Sep
  • Re: varchar vs char speed improvementPooly27 Sep
    • Re: varchar vs char speed improvementMartijn van den Burg28 Sep