Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SCAN and query result
Message
 
To
03/08/2001 16:59:13
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00537855
Message ID:
00539675
Views:
26
>>One thing you absolutely do not want to do is add a UDF to a SQL query. VFP will run the UDF with every row of the source cursor, which KILLS performance.
>
>This is not an absolute truth. There can be situations where a UDF can simplify what would otherwise be a very complex query.
>
>If it looks like a UDF has merit, one tests it with a representative data set; if it performs satisfactorily (considering the alternatives), then one incorporates it.

Gerry;

I will buy that. There are no absolutes, absolutely!:)

Tom
Previous
Reply
Map
View

Click here to load this message in the networking platform