>>Perhaps not, or if so, only slightly. Macros have always slowed down the execution of code.
>
>Greg,
>EXECSRIPT() is equal to:
>STRTRAN(variable, [some temp file.PRG])
>COMPILE [some temp file.PRG]
>DO [some temp file.Fxp]
>ERASE ([some temp file.*]
>
>So how this could be faster that macro?
After some experimenting with using ExecScript versus Macros (in my next release of Query) I decided to use a Macro to execute the SQL statement instead of ExecScript. There was a 2.5% increase in speed with the Macro. WOW, Now we are flying. :-)
Greg Reichert