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.
>