Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SCAN and query result
Message
From
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:
00539672
Views:
21
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform