Hi there,

I have a proc calling another a statement with an in-clause referring to a
recursive proc, as

Create procedure proc_1 returns (F2 integer)
as
for select F2 from proc_2 where F1 in (select F1 from proc_recursive) do
suspend;
end

Run separately, the procs are lightning fast, also the recursive one. But
put together like this, something happens, resulting in a 10 sec response
even for the smallest result sets.

Any clue?

/Martin