Subject | Re: [ib-support] Re: Database grows rapidly (3 to 770MB) when using BLOB views/UDFs |
---|---|
Author | Ann W. Harrison |
Post date | 2002-03-24T16:50:07Z |
At 10:44 PM 3/23/2002 -0400, Claudio Valderrama C. wrote:
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.
>Isc_cancel_blob is the main wayAnd that, probably, is the cause of the problem. Remember that
>
>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.
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.