VChar vs VText

[Ruslan Zasukhin]

On 11/25/05 9:43 PM, "jda" <jda at his.com> wrote:

Hi Jon,

> I'm going to add about 12 new fields to my db (API way). They could
> be VText (which I mostly use) or VChar (I don't care if they are
> limited to 1K or so of text). Is there any *real* advantage of one
> over the other (storage-wise)? I expect these fields will generally
> store from 5-200 characters or so.
> 
> If I use VChar, what's the smallest segment size that conserves
> space? I recall something like 5024.
> 
> If VText, what's the smallest that makes sense (32)?

Vtext MUST be choose if you know that document can be very big,

If you say 1K is okay, then use VarChar


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]