Walter Meester
HoogkarspelNetherlands
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,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only