Bruce,
My final solution, reducing the time from 5 seconds to 0.057 seconds (80X improvement) included strict optimization (unintentionally missed on the last, offending, SELECT) and replacing ORDER BYs with INDEXing intermediate CURSORs on the fly. Thanks.
David
>>The following code works, it prints "Pick Tickets" for a Mail Order house. But for the life of me, I can't figure out why the last piece of the puzzle, PTLinePart, the last Procedure of four, takes 90+% of the entire PicTicView's time.
>
>Could be the ORDER BYs -- try removing them, see how it is. If that's it, you could speed it up by just indexing the cursor after the SQL.
>
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