Subject RE: [IB-Architect] Insert Speed
Author Claudio Valderrama C.
> -----Original Message-----
> 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.

Does the difference between level1 and level2 depend specifically on size?
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 stream
> 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.

Are these two types meaningful only to the engine itself? Are they
visible/manageable in any way by an application?
I understand I should ask Ann for that. ;-)