VChar vs VText

[Ruslan Zasukhin]

On 11/26/05 12:33 AM, "jda" <jda at his.com> wrote:

> Hi Frank,
> 
>> You do not  set the segment size with a VarChar, instead it is the
>> maximum size.
> 
> Ah, of course. Should have remembered that...
> 
>>  1022 is the minimum value you should use, at least for double byte
>> encodings like UTF-16 which is the default.
> 
> Wasn't that for V1? I thought it changed in V2 to something over 5000. Ruslan?

Best VarChar size in v2 for UTF16 strings is 1022

        1022 * 2 = 2044

2 max big string on page 2044 * 2 = 4088.

So we get 4Kb page


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