Sizes and checks

[Ruslan Zasukhin]

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.


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