Smart BLOBs

Posted in 2003

Thomas Girsch — Mon, 30 Jun 2003 20:54:04 GMT — source: Usenet: comp.databases.informix

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?