Thanks John,
Big bagoonza was tried first, it was way too much for VFP, I needed to break it down. The solution was get optimized when I thought I was, and INDEX my intermediate CURSORs on the fly so that the following SELECTs would be optimized.
David
>Hi David ---
>
>Because, maybe, it is the result of a result of a result. You are following great data normalization procedures, BTW. But if all three procedure automatically follow each other, maybe what you need instead is either a big bagoonza SELECT that incorporates all three SELECTs -or- try substituting paramterized views for all three and requery them in order. It might help.
>
>
Précédent
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