segmentSize

[Ruslan Zasukhin]

On 6/14/05 12:43 AM, "Sean Wilson" <snw at paradise.net.nz> wrote:

> Hi Ruslan,
> 
> How can I calculate the optimal segmentSize for a database, and how does
> the segmentSize impact efficiency, speed, ...?

Hi Sean,

Hard to say what is optimial

* for dbs in 5Mb and more I think you can use 8 16 or 32 Kb segment

* for very small dbs which will have or MUST have size < 1Mb you will prefer
segment in 2KB



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