Subject Re: [Firebird-Architect] blobs causes table fragmentation.
Author Jim Starkey
Dmitry Kuzmenko wrote:

>Hello, All!
>
>As I understand current behavior, blobs less than 256 bytes are
>stored at the same data page, in record. If blob is bigger it
>is stored at blob page, not data page.
>
>There are some systems that store blobs with different size,
>so blob data is spreaded between data and blob pages.
>This makes table more "fragmented" and seriously slowdown
>record retrieval if 'select' does not selects blob fields.
>
>
>
This is all wrong. Small blobs are stored intermingled with data.
Large blobs are stored in separate pages (not touched during exhaustive
scan) with only the control structures stored on regular data pages.

>The suggestion is - to add some header page flag that
>will disable blob storing at data page.
>
>
Too late. I did that in 1984.