Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Macro Substitution in a SQL statement
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00052240
Message ID:
00052372
Views:
39
>Ed- on review of my DevCon notes, I believe you're right. I think that I was mentally combining the results of two facts:
>
>1. SELECT statements will evaluate UDFs for every line.
>2. Macros slow down a scan loop because VFP re-evaluates them

Ed must be right -- I use macros in many queries of a million records or so, and as long as they're indexed properly, they run virtually instantly...As you say, though, UDFs will really bog things down. The SCAN makes sense, too...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Reply
Map
View

Click here to load this message in the networking platform