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 ?

Thanks,

Nico Callewaert


-----Oorspronkelijk bericht-----
Van: Svein Erling Tysvar
[mailto:svein.erling.tysvaer@...]
Verzonden: donderdag 21 maart 2002 11:14
Aan: ib-support@yahoogroups.com
Onderwerp: Re: [ib-support] SP question / fetching query results


Nico,
"I have a problem, what's the solution?" isn't the easiest of questions to
answer. Please provide us with more information, including the query in
question, size of tables, indexes, source of your SP and the plan chosen.

As for a general answer, I can only say that avoiding NATURAL in plans
isn't the only thing that matters. Using too many or the wrong indexes can
slow down a query as well.

Set


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/