Hi,

> 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?

With only this little info?

Nope.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com