Re: Smart BLOBs

Posted in 2003

Noel — Thu, 3 Jul 2003 06:57:20 +0100 — source: Usenet: comp.databases.informix

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