Select * From Table1 Where nrdoc In (Select nrdoc From Table2)This command works perfectly in VFP5. It's awful slow in VFP9.
Select fieldlist Into Cursor stmp Select Stmp.Cd, Stmp.Gest, Sum(stmp.Stoc) From Stmp ; Group By Stmp.Cd, Stmp.Gest ; Order By Stmp.Cd, Stmp.Gest ; Into Cursor Stmp2 Do (_GenXTab) With 'stmp2', .T.,.T.,.T.,,,,.T.,0,.F.Time taken to do the above: VFP5: 10 seconds, VFP9: 140 seconds. 1400% performance penalty. Stmp cursor has 15300 records.