Subject Re: [ib-support] Re: Database grows rapidly (3 to 770MB) when using BLOB views/UDFs
Author Ivan Prenosil
> From: Claudio Valderrama C.
...
> I think that isc_cancel_blob() is much better than isc_close_blob() in your
> case because the returned blob will be taken by BLB_cancel() internally.
> BLB_cancel() does an immediate job of trying to get rid of the db pages
> allocated by the temporary blob. Instead, with the isc_close_blob() path you
> rely on garbage collection to proceed later...

Hmmm, how can the temporary blob (returned from UDF) be garbege collected
if it was not assigned to any row (and thus converted to permanent blob) ??

Ivan
http://www.volny.cz/iprenosil/interbase