... well it seems so to me.

I upgraded VFP7 to VFP9 today, tried out my one and only mega-app and found a drastic reduction in performance in the first area I checked. :-(

Having spent time with the coverage profiler on both versions I have tracked the performance hit down to 3 consecutive SUM functions. Below is the code I am running with the results from the coverage profiler for both VFP7 and VFP9. As can be seen, the 3 SUM function lines (lines 8,9,10) together take 538 times longer to run in VFP9 than in VFP7.

The salesdet table has 46,000 records. It has indexes on salesdet.sono and on left(salesedet.cat,1) to make sure the SUM function is optimizable.

Any one any ideas? Because otherwise, VFP9 is going back in the box!

Thanks
Barry Sutton.

PS This is on a standalone PC - so not even a network issue.

.........................

USE C:\ALBA2\SALESDET

jctable = "salesdet"
jcId="36578"

SELECT (jctable)
SUM salesdet.qty*salesdet.price TO jnGoodsval ;
FOR salesdet.sono = jcID
SUM salesdet.qty*salesdet.price TO jnPlantsVal;
FOR salesdet.sono = jcId AND LEFT(salesdet.cat,1)<>"S"
SUM salesdet.qty TO jnPlants ;
FOR salesdet.sono = jcId AND LEFT(salesdet.cat,1)<>"S"

jngoodsval = ROUND(jnGoodsVal,2)
jnplantsVal = ROUND(jnPlantsVal,2)


RETURN

"Coverage Results"
VFP7
0.001828,,program2,2,c:\temp\program2.fxp,1
0.000258,,program2,4,c:\temp\program2.fxp,1
0.000059,,program2,5,c:\temp\program2.fxp,1
0.000060,,program2,7,c:\temp\program2.fxp,1
0.000354,,program2,8,c:\temp\program2.fxp,1
0.000221,,program2,9,c:\temp\program2.fxp,1
0.000166,,program2,10,c:\temp\program2.fxp,1
0.000067,,program2,12,c:\temp\program2.fxp,1
0.000060,,program2,13,c:\temp\program2.fxp,1
0.000056,,program2,17,c:\temp\program2.fxp,1
total 0.003129 secs


VFP9
0.003723,,program2,2,c:\temp\program2.fxp,1
0.000293,,program2,4,c:\temp\program2.fxp,1
0.000057,,program2,5,c:\temp\program2.fxp,1
0.000064,,program2,7,c:\temp\program2.fxp,1
0.165780,,program2,8,c:\temp\program2.fxp,1
0.116974,,program2,9,c:\temp\program2.fxp,1
0.116236,,program2,10,c:\temp\program2.fxp,1
0.000239,,program2,12,c:\temp\program2.fxp,1
0.000059,,program2,13,c:\temp\program2.fxp,1
0.000053,,program2,17,c:\temp\program2.fxp,1
total 0.40879 secs

vfp9 is 538 times SLOWER than vfp7 on the SUM functions