Re: varchar vs char speed improvement

2005-09-28 Thread Martijn van den Burg
On Tuesday 27 September 2005 11:59, Pooly wrote: > 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

Re: varchar vs char speed improvement

2005-09-27 Thread Pooly
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

varchar vs char speed improvement

2005-09-26 Thread Ow Mun Heng
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. --