Sizes and checks

[Ed Kleban]

On 12/28/05 12:05 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> On 12/28/05 7:52 PM, "Ed Kleban" <Ed at Kleban.com> wrote:
> 
>> 2) V4RB Reference page 36 notes for VDataBase.Create that the default
>> cluster inSegmentSize is 32KB.
>> 
>> What are the benefits or disadvantages of making this bigger or smaller,
>> such as 8 KB, 16 KB, 64 KB or 128 KB?
> 
>> Is there benefit to tuning this parameter based upon available memory at
>> runtime on a users machine, or is it more dependent upon the inherent nature
>> of the tables and the types of data access being performed?
> 
> Segment size affects only
> 
> A) how many of disk is allocated for logical file, when it need new space.
> 
> B) the small segment size, the more segments a file have.
>     so the longer is list/tree of segments to check to find required.
> 
> Btw, segment size affect initial size of _empty_ db.
> You could note that empty db can east 5-10-20 MB.
> 
"east" ?