Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Group by clause in vfp8
Message
De
19/04/2003 06:07:55
Walter Meester
HoogkarspelPays-Bas
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00774269
Message ID:
00779467
Vues:
28
Goerge,

>This is very similar to what must occur when using a function such as MIN() in an SQL statement. Only by comparing each row to the current minimum can the function determine the minimum value. This will result in the number of rows examined number of comparisons.
>
>There's no argument here to the contrary, Walter. This is what happens.

I never said that there is no overhead at all. The question is if its measurable. Also your example be compared with the SQL statement containing the MAX() or MIN() function because it is interpretated for each iteration as only ones in a SQL statement. The MIN() and MAX() function is executed for each row in VFP underlying C/C++ or assembly code. There is absolutely no comparison between executing the MIN and MAX function in a few lines of C/C++ code and interpretating VFPs Pcode. Don´t forget that the undocumented ´last physical´ row feature when grouping rows also requires some kind of function to keep track of the last row value of not aggregated columns.

Walter,
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform