Subject RE: [IB-Architect] Insert Speed
Author Ann Harrison
At 09:20 PM 4/9/00 -0400, Claudio Valderrama C. wrote:
> > -----Original Message-----
> > From: Jim Starkey [mailto:jas@...]
> > 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.

At 09:20 PM 4/9/00 -0400, Claudio Valderrama C. wrote:

> 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?

Yes.

> > From: Jim Starkey [mailto:jas@...]
>
> > The engine supports two types of blobs: segmented blobs and stream
> > blobs.

At 09:20 PM 4/9/00 -0400, Claudio Valderrama C. wrote:

> 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. ;-)

Yes, they are different to the engine. There's an option
on blob create that specifies which type of blob you get.

Ann

(At least I hope there is)