>Sergey (and others),
>
>The original message said that this took about 1 minute in FP but now takes 7+ minutes.
>
>Shouldn't there be some reason other than the code/data that makes the difference?
>
>Just thinking out loud.
Jim,
Yes and the reason is most likely memory usage. VFP7 has a much larger memory footprint than FP so there is less memory available for looping through records in the two tables. We were never told how much memory is in the machine though.
My goal in responding was to first optimize the code, then find out what the difference in timing is and address that then. Optimized code may eliminate the problem as it may require less memory and therefore eliminate the memory exhaustion.