>>VFP Users:
>>
>>Does anyone know what causes Visual Foxpro 9 to slow down dramatically compared to version 6?
>>
>>Maybe there are some settings to add to CONFIG.FPW that can speed it up?
>>
>>Thanks in advance.
>
>Make sure that cpdbf() for all your tables show the same value as cpcurrent(), if not VFP9 will not optimize your queries. This is not a bug, it's a fix. Earlier versions could select wrong data with rushmore if cpdbf() and cpcurrent() did not match. That's why rushmore is disabled in these cases in VFP9.

I did not know that. Thanks.