<< Where in the form does the code live? >>
It doesn't matter -- EEP or separate file called with RUN. As long as the call to the code is from inside a form (or stored procedure) I see the slower behavior). << Can you place the code in the ON BEFORE START eep? >> No, I need some variables from the form to SELECT against. << As a workaround in 7.6, I used lots of TEMP vies and TABLES. >> I thought I was going to be doing that kind of optimization here to reduce the 3.6 second execution time. Imagine my surprise when, having moved the code to TEMP.PRG to work on it, I found it ran in 0.2 seconds! << I know that there have been a number of engine fixes for 7.6 but also know that it is out (going?) of service >> Client has promised me an upgrade by January of 2012, for the time being I'm using 7.6. -- Larry
