Subject SP question / fetching query results
Author Nico Callewaert

I have a stored procedure with a loop that is doing some selects. It
takes about 7 seconds for the procedure to execute. I work with IBO and
when the procedure is executed, I have a screen "Fetching query results" for
about 1.5 minutes. The result set is somewhere 300 rows only. So, I've
set FetchAll to true. When I look at the plan, it's using indexes, nothing
"NATURAL" order. It's strange, when I check with IB_Console, the procedure
takes only 7 seconds to execute, but it seems the scrolling in the dataset
takes very long.

Any idea ?
Thanks, Nico Callewaer