Select * From Table1 Where nrdoc In (Select nrdoc From Table2)

This command works perfectly in VFP5. It's awful slow in VFP9.

or:

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.

What can I do to make VFP9 to work as fast as VFP5? (I have to mention both tests were done on same tables - there are no environment differences between VFP9 and VFP5).

I am aware that VFP9 disables Rushmore if dbf's codepage does not match OS codepage. However, I have NO control where my application goes. What now? I am supposed to CPZERO and rebuild CP every time the application is installed? Or what? Do I miss anything here?