Subject Re: [firebird-support] Execute Statement eating memory
Author Helen Borrie
At 01:05 PM 11/01/2006 +0000, you wrote:
>I have some code like EXECUTE STATEMENT 'EXECUTE PROCEDURE blabla'
>This procedure does a two table join and performs some value checking
>and inserting into a table in a FOR loop.
>The join produces aprox. 9000 records.
>While running this my pagefile grows until available disk space is
>Anyone have any idea what can be the cause for this?

You're running what's sometimes known as "a runaway query" - in this case,
the procedure logic is probably executing an infinite loop. Show the
actual code of the two procedures so that it's possible to comment on what
the procedure is *actually* doing, rather than what you think it ought to do...