>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

Which command do you use to retrieve these 5 records?