Kelly,

There're two cases I know about when queries could run slower in VFP9.
1. When index that could be used for optimisation includes STR() function. It's a bug
2. When CPDBF() <> CPCURRENT(). This behavior change (undocumented) in VFP9.

>We recently did a test run for converting our 8 sp1 application to 9 and have run into some issues. When certain queries are ran the execution time goes from 15-20 seconds to 10 minutes! After walking through some of the code I have noticed that part of the query is not working properly, in 9 only! The exact same query works just fine in 8. They are being ran off of the same data as well. The coding is for a quasi multidetail line report but it is not limited to this select statment. Basically the test code took the contents from two cursors and inserted them into one cursor for reporting. The probelm occurs when the second curusor is loaded, it loads all the recrods instead of the single record needed. Is there a program setting that I am missing here (tried the report behavior one - no luck) or something?
>
>Just starting to do some digging