.blb file not shrinking after deleting ALL entries

[Charles Yeomans]

On Feb 16, 2004, at 11:17 AM, Andrew Sinning wrote:

> What is the proper setting for the BLOB segment size if I expect the
> entry to be at lease 10Kb, but of no maximum size?
>
> The docs state:
>
> . If you want to store 100KB BLOBs, then the segment size is not
> required to be 100 K. It
> can be 10KB, 30 KB, or even 200KB.
>
> So, it doesn't matter?

It matters.  As I understand it, BLOBs are stored as linked lists.  So 
if you store a 100kB BLOB using a segment size of 10kB, Valentina will 
write approximately 10 segments to disk. which may or may not be stored 
contiguously.  Thus a small segment size probably has some impact on 
performance.  On the other hand, a large segment size can waste a lot 
of space.

But so far, Valentina has proved to be so fast that I haven't felt the 
need to worry about this sort of optimization.

Charles Yeomans