Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Macro substitution and evaluate - which to use
Message
 
 
To
20/07/2007 16:31:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01241954
Message ID:
01242494
Views:
24
>>>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. :-)

Congrats! :)
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform