|Subject||RE: [IB-Architect] Insert Speed|
|Author||Claudio Valderrama C.|
> -----Original Message-----Does the difference between level1 and level2 depend specifically on size?
> From: Jim Starkey [mailto:jas@...]
> Blobs are stored in one of three ways depending on size. Blob that fits
> on a regular data page is a level 0 blob, is comingled with records, and
> if possible, will be stored on its parent's data page. Large blobs are
> stored on dedicated blob pages with either a list of blob pages (level 1)
> or a list of blob pointer pages (level 2) comingled with records as
> per a level 0 blob.
When I update a level2 blob and the new version is very small, it's stored
as blob level0 if possible?
> The engine supports two types of blobs: segmented blobs and streamAre these two types meaningful only to the engine itself? Are they
> blobs. Segmented blobs maintain segment boundaries with embedded
> segment lengths. Because of the embedded lengths, direct access
> isn't supported for segmented blob. Stream blobs are just stuff.
visible/manageable in any way by an application?
I understand I should ask Ann for that. ;-)