VChar vs VText
jda
jda at his.com
Fri Nov 25 17:04:41 CST 2005
>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
>
Is there any advantage to VarChar (remember, typical data of 5-200
chars per fields, UTF-16 encoding)? And what segment size is optimal
(for saving storage space)?
Jon
More information about the Valentina
mailing list