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