Subject Re: [ib-support] Re: Database grows rapidly (3 to 770MB) when using BLOB views/UDFs
Author Ann W. Harrison
At 10:44 PM 3/23/2002 -0400, Claudio Valderrama C. wrote:

>Isc_cancel_blob is the main way
>
>When a blob is created, it's chained to the attachment, to the transaction
>and to the linked list of blobs held by the transaction.

And that, probably, is the cause of the problem. Remember that
a UDF does not inherit transaction or connection context so temporary
blobs created by a UDF aren't linked into anything. 80% certainty,
I haven't walked through the code.

Blob filters. Absolutely.


Regards,

Ann
www.ibphoenix.com
We have answers.