Problem I am having is, if I compile and run the program using VFP7 or 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.and then downloaded the SP1 and install on top of it. still the problem reamin same.

Please help me to overcome this problem.

Thanks in Advance

Deen