Subject RE: [ib-support] SP question / fetching query results
Author Nico Callewaert

Exactly the same, until I scroll down. The answer of Frank is explaining
a lot about this.

Thanks, Nico

-----Oorspronkelijk bericht-----
Van: Ann W. Harrison [mailto:aharrison@...]
Verzonden: donderdag 21 maart 2002 17:07
Onderwerp: RE: [ib-support] SP question / fetching query results

At 11:34 AM 3/21/2002 +0100, Nico Callewaert wrote:
>Thanks for the reply, but my question was : Why if a SP takes only 7
>to execute, why the server needs 1.5 minutes to fetch only a few hundred
>records ? The data is displayed in a grid, within 7 seconds there are
>enough rows displayed to fill the screen, but when I scroll down in the
>until the end, it needs a lot of time before I can see the last record...
>That's why I wonder : is the whole stored procedure executed in one time ?
>or just enough rows to fill the grid on the screen ?

If you invoke the stored procedure through ISQL, how long does
it take to get the results?


We have answers.

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to