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. |