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.