Subject Re: High memory usage
Author Adam
--- In firebird-support@yahoogroups.com, Rodrigo Gonçalves
<keitarobr@g...> wrote:
> No. Just SQL statements and some procedures (which do nothing more
than
> just update or insert single records in some tables).
>
>

I will interpret that as you do not have any triggers on those tables
you are updating or inserting that internally call UDFs or other
procedures that contain UDFs. Also that any records impacted within
the triggers do not cause other triggers that contain UDF functions.

It is a bit confusing I know, but when we had a memory leak at one
stage I traced it back to an function called within a UDF call that
was not freeing some variables.

Although it was never called directly by any SQL, it was called
within a trigger on a table that was frequently modified. Anyway,
just pointing out a likely cause, not necessarily the problem you are
having.

Adam