View Single Post

   
  #3 (permalink)  
Old 02-27-2008, 05:18 AM
Mark A
 
Posts: n/a
Default Re: SOS for long varchar

"Rhino" <no.offline.contact.please@nospam.com> wrote in message
news:437bf.14807$J14.604861@news20.bellglobal.com. ..
> <snip>
> If that is not acceptable, I suggest that you may want make the Comentario
> column a VARCHAR(6000). Again, the page size you use will have to be at
> least 8K, otherwise the creation of the table will fail.
>
> Rhino
>

Regular varchar will hold almost up to 32K and will perform much better.
This is because long varchar cannot use bufferpools and all I/O is a direct
read/write from/to disk.


Reply With Quote