Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group by clause in vfp8
Message
 
To
21/04/2003 04:29:59
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00774269
Message ID:
00779738
Views:
37
>>MIN() would be a function in the true sense of the word if it received a parameter and returned a value. In this case, it results in the smallest value of those it's received. Therefore, each field has to be examined and compared, internally in this instance. Regardless of how one equates them, it is, nonetheless, a function.
>
>It is only intepretated ones....
>
Walter,

Nope! Each record has to be examined, unless an index exists on the individual field. In the latter case, then a binary search can be done to determine the smallest value. This still results in more comparisons than are necessary if the function is omitted.

The code is interpreted once, the function is called multiple times.
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform