2005/9/27, Ow Mun Heng <[EMAIL PROTECTED]>: > 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?
I guess benchmarks depends on your data... varchar take really less space, and so is faster to read from disk, so you could improve speed in having varchar ! But since it cause dynamic row format, it can makes think slower. > > 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 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
