>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.