Ann,

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
Aan: ib-support@yahoogroups.com
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

seconds

>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

grid

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


Regards,

Ann
www.ibphoenix.com
We have answers.



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/