Subject Re: [firebird-support] does any has an idea why this stored procedure takes so much memory?
Author Lucas Franzen
Hello Holger,


>> sql='select count(*) from rdb$relations WHERE
>>RDB$RELATION_NAME='''||t||'''';
>> execute statement :sql into :ex;

I think execute statement has to be prepared each time in the loop so
this will sum up pretty much as I see your loop is executed quite often.


Luc.