>Hi friends
>recently we upgraded to vfp9 from vfp8 and we noticed our app running slowly compared to vfp8. there is no code changes but still there is noticeable difference especially some screens in our app.
>
>are there any knows issues in vfp9 we should look for ?
>how do i trouble shoot such issues ?
>Thanks for ur advise.
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.