So what do you suggest Helen I use to make best use of space if I would
want to create a log file of all actions in a system happening and the
values that were changed where the larges value is +- 100 bytes big ,
VARCHAR(100) filed. but most values changed will be in the range of 20 to
30 bytes ?

At 03:51 PM 1/17/2004, you wrote:

>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
>
>
>
>
>Yahoo! Groups Links
>
>To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
>To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/