Subject Re: [ib-support] Re: Database grows rapidly (3 to 770MB) when using BLOB views/UDFs
Author Claudio Valderrama C.
""mircostange"" <mirco@...> wrote in message
news:a74997+q1q6@......
> Hm, well thank you for the hint, but could you be a little more
> specific?
> I have no idea what could be wrong with the UDF. Memory leakage could
> be an issue, but this should be increasing the RAM usage of ibserver,
> not the database - right?

Does your UDF create a blob or not internally?
If you get blob id 40 from the db, you can't return such blob to the client,
since you are changing it. Hence, I think your UDF creates a new, temporary
blob. Is this true or not? Otherwise, I don't have any idea how your thing
works.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing