Problem I am having is if I compile and run the program using VFP7 VFP6 it works fine but when I compile and run the same program using the VFP9 it gives slow response.I am not using any complicated SQL commands.

For an example if I try to retrive 5 records out of 800000 records VFP7 and VFP6 provide the results with in 3 sec where as the same thing in VFP9 takes more than 10 Sec.


I install the VFP9(Professional Upgrade Version) on top of VFP7.

Please help me to overcome this problem.

Thanks in Advance

Deen