Subject | Re: [firebird-support] Correct Page Size for the database. |
---|---|
Author | Ivan Prenosil |
Post date | 2006-09-11T11:35:56Z |
"Ann W. Harrison" wrote:
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.
Ivan
> Blobs aren't compressed,It would be inefficient - when creating a blob, FB does not know
> 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.
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.
Ivan