Subject | Re: [ib-support] Re: Database grows rapidly (3 to 770MB) when using BLOB views/UDFs |
---|---|
Author | Ivan Prenosil |
Post date | 2002-03-21T17:29:54Z |
> From: Claudio Valderrama C....
> I think that isc_cancel_blob() is much better than isc_close_blob() in yourHmmm, how can the temporary blob (returned from UDF) be garbege collected
> 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...
if it was not assigned to any row (and thus converted to permanent blob) ??
Ivan
http://www.volny.cz/iprenosil/interbase