Subject | Re: [firebird-support] does any has an idea why this stored procedure takes so much memory? |
---|---|
Author | Lucas Franzen |
Post date | 2004-02-17T15:14:54Z |
Hello Holger,
this will sum up pretty much as I see your loop is executed quite often.
Luc.
>> sql='select count(*) from rdb$relations WHEREI think execute statement has to be prepared each time in the loop so
>>RDB$RELATION_NAME='''||t||'''';
>> execute statement :sql into :ex;
this will sum up pretty much as I see your loop is executed quite often.
Luc.