|Subject||RE: [firebird-support] Re: DB w/ 16kb page site and BLOB fields size w/ content just 40bytes by record|
> 22.11.2012 1:16, Leyne, Sean wrote:Picky, picky, picky ;-]
> > If that size is less than the free space on the data page, then the
> > blob would be stored with the data, taking only 40 bytes.
> I'd say it gonna take 8 bytes per blob id + up to 8 bytes per alignment (both
> compressed) + 28 bytes per blob header (uncompressed) + 40 bytes of data
I never knew that a blob had up to 44 bytes of overhead, which needs to be considered when thinking about if the blob can fit on the data page, and not need its own blob page(s).