Subject | Re: [Firebird-Architect] Fw: Performance |
---|---|
Author | Jim Starkey |
Post date | 2003-06-23T17:37:03Z |
Leyne, Sean wrote:
Any reference will cause a record to be reassembled if fragmented and
unpacked. Blobs,
however, are stored separately from the record, and are only fetched if
referenced. The
engine makes some effort to store block (and blob roots) on the same
page as the parent
record, but there are no guarantees.
>My question is:Of course not.
>
>Does the engine really unpack blobs which are not part of the select
>criteria?
>
>
Any reference will cause a record to be reassembled if fragmented and
unpacked. Blobs,
however, are stored separately from the record, and are only fetched if
referenced. The
engine makes some effort to store block (and blob roots) on the same
page as the parent
record, but there are no guarantees.