On Wed, Sep 30, 2009 at 9:19 PM, Alan McDonald <alan@...> wrote:

> Following on from a previous thread on memory use:

I can reproduce the leak too:

0) create this procedure:
CREATE PROCEDURE TESTMON
as declare variable id bigint;
begin
for select mon$statement_id
from mon$statements
into :id do begin end
end

1) Open an attachment, start a transaction and leave it be.
2) Open another attachment
3) check memory usage
4) Run the following a couple thousand times:
start transaction;
execute procedure testmon;
commit;
5) check memory usage again. It's higher than before. If you go back
to step 4 an repeat, it keeps on climbing.

hth,
--
Douglas Tosi
www.sinatica.com