Subject Re: [firebird-support] Blob size
Author Helen Borrie
At 12:31 AM 18/01/2004 +1100, I wrote:
>It starts by allocating and filling one segment of
>the size it chooses, then it keeps on allocating and filling segments as
>required until the whole stream is stored.

I should have mentioned that the segments are allocated from pages - so the
engine has to allocate pages (or find free ones) before it can start
filling segments.

A segment can run over multiple pages; or there can be many blobs and
segments on one page.

So your idea of a 20-byte blob only using 20 bytes probably isn't too
relevant. An 8K page might need to get allocated just to store a single
segment...

/heLen