I have a feeling I already know (and hate) the answer to this question: In
an sbspace, is it ever possible to have more than one BLOB on the same page?

Our problem is that we have a wide disparity of sizes of the BLOBs in our
system. Many of them can be as small as 100 bytes, but others are as large
as 100KB or more. If all of those thousands of 100 byte records are taking
up a full page each, this could be problematic, insofar as there will be a
ton of wasted space.

Has anyone tackled this before?

Yes. Typically an app will have a variety of average blob sizes. For
example you may have a 100,000 jpg's averaging say 50k, a million scanned
document TIF images averaging say 25k, a million word documents average size
22k, and 2 million text blobs averages size 1-2k.

In such a case you would have 4 BLOB or SMARTBLOB spaces each with pages
sizes of say 52k, 27k, 24k, and 2/4k respectively. This way a 400 byte text
blob will not waste a whole 50k BLOB page.

Noel

"Thomas Girsch" <tgirsch@worldnet.att.net> wrote in message
news:Mr1Ma.30242$0v4.2230438@bgtnsc04-news.ops.worldnet.att.net...
> I have a feeling I already know (and hate) the answer to this question:
In
> an sbspace, is it ever possible to have more than one BLOB on the same
page?
>
> Our problem is that we have a wide disparity of sizes of the BLOBs in our
> system. Many of them can be as small as 100 bytes, but others are as
large
> as 100KB or more. If all of those thousands of 100 byte records are
taking
> up a full page each, this could be problematic, insofar as there will be a
> ton of wasted space.
>
> Has anyone tackled this before?
>
>