Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Group by clause in vfp8
Message
 
À
21/04/2003 04:29:59
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00774269
Message ID:
00779738
Vues:
36
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform