Subject | Re: [Firebird-Architect] blobs causes table fragmentation. |
---|---|
Author | Jim Starkey |
Post date | 2004-10-04T14:03:52Z |
Dmitry Kuzmenko wrote:
Large blobs are stored in separate pages (not touched during exhaustive
scan) with only the control structures stored on regular data pages.
>Hello, All!This is all wrong. Small blobs are stored intermingled with data.
>
>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.
>
>
>
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 thatToo late. I did that in 1984.
>will disable blob storing at data page.
>
>