>>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.

PMFJI,

But I was messing with the SYS(3050) function today in order to increase performace of VFP while it is in the ForeGround. I'm using the following in my application config.fpw file to help performance in general:

COMMAND = SYS(3050,1,(VAL(SYS(1001)) /4) * .85)

The .85 above is just a percentage of the entire pool of memory available to VFP. Would this be of use here?

Doug