Disappearing BLOB space

Posted in 1993

Dave Snyder — Wed, 24 Mar 1993 18:46:27 -0500 (EST) — source: Informix-list mailing list archive (1991-1998)

I had a customer ask me the following question... We have a rootdbs and also a blob-space (for TEXT blobs) When we delete a row from the table which has a blob, why isn't that deletion reflected in the free-page count for the blob-space? Also, if we right-of-way add a new row to the table and include a blob, the free-page count immediately reflects the addition of the blob. At first I thought that this was something similar to the way deleted rows in Informix-SE don't reduce the size of the data file. But when you add a new row in SE, the size of the data file doesn't grow until you fill up all the holes left by deleted rows. This doesn't seem to be the case in ONLINE's blob-space. Any ideas? DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.9 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com