Dennis,
As was suggested, check out your Rushmore optimization. If you are using indexes that link several fields, be sure you include all of these fields in a JOIN or WHERE clause. For example if you have an index on LastName+Firstname but your SELECT has the clause "WHERE LastName="Lindeman" the SELECT will not be optimized. You need to change the code to: "WHERE LastName+FirstName = "Lindeman".

HTH
Barbara

>I am in the process of converting a FPD application to VFP. The conversion was looking good until a Beta version was released in late August for group testing. It was quickly discovered that queries that take 2 or 3 seconds in the FPD version, take 20 to 30 seconds in the VFP version.