empty db size

Andrew Sinning andrew at learningware.com
Thu Jul 14 14:09:31 CDT 2005


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.

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.

Thanks.


More information about the Valentina mailing list