Subject | Re: [ib-support] Re: Database grows rapidly (3 to 770MB) when using BLOB views/UDFs |
---|---|
Author | Claudio Valderrama C. |
Post date | 2002-03-18T09:03:11Z |
""mircostange"" <mirco@...> wrote in message
news:a74997+q1q6@......
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
news:a74997+q1q6@......
> Hm, well thank you for the hint, but could you be a little moreDoes your UDF create a blob or not internally?
> 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?
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