Subject Re: [firebird-support] Correct Page Size for the database.
Author Ivan Prenosil
"Ann W. Harrison" wrote:
> Blobs aren't compressed,
> on the other hand, blobs are stored front to back, so if you have a
> blob that's two and a quarter pages long, the first quarter page goes
> on a data page and the rest goes on two completely full blob pages.

It would be inefficient - when creating a blob, FB does not know
its size in advance, i.e. it can't put the first quarter page on data page directly,
it would require to store whole blob somewhere first and then
move it to final place.

If a blob is larger than datapage, than it is always stored on blob pages,
even if the last page will remain nearly empty.