Can you post the select which is slower in VFP9?
>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.
>
>>Deen
--sb--