SET ORDER, SET FILTER
Also, the amount of memory you have available, probably less in the application, than when run alone from a prg.
Vlad
>Hello everybody,
>
> Can anybody tell me which SET can affect query speed (I know SET
> Optimize)? May be there are some other SET that can slow down query?
> I'm asking this because when I run my query alone in prg, it takes around
> 60 seconds for first time and then around 38 seconds for subsequent runs.
> But when I run the same prg within application, the first run time is 115
> secs and the subsequent calls takes 68-70 secs. Obviously, something
> slows down this query.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement