empty db size

[Ruslan Zasukhin]

On 7/14/05 10:09 PM, "Andrew Sinning" <andrew at learningware.com> wrote:

> On Monday you helped me solve a problem by increasing the segment size
> in my db.  So instead of:
> 
>       CreateDatabase(valentinaDB, filePathName,  4,  1*1024)
> 
> I now use
>    
>   CreateDatabase(valentinaDB, filePathName,  4,  32*1024)
> 
> The draw back is that my _empty_ database is now nearly 7Mb (5Mb .dat
> and 1.9Mb .ind).  It does zip compress into something much smaller, but
> this does still seem very large.

But what you going to do ?

    Distribute empty db ?
    or fill it by data?   Then what will be size of full db ?

 
> Can you please discuss how the segment size ultimately impacts
> performance?  I did find that a segment size of 8*1024 did hurt
> performance somewhat.

8Kb slow down for you? Hmm, somebody have told that for him 8K was the best
performance. 

I think 8-16-32 should not differ too much
Very small segment can slow down


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