>>We recently upgraded from Fox 2.6 to Visual Fox 6.0. Some of my queries run so much slower in the new version. For example, I had three tables linked and indexed and the query was 33% complete after 15 minutes. I didn't wait to see how long it would actually take. The same query, without even indexing the tables, only took 1 minute in Fox 2.6. Has anyone else experienced this? Is there something that I'm doing wrong?
>>
>>Thanks.
>
>In addition to what Bill has said, how much memory is in the machine? VFP has a much larger memory footprint than 2.6 did.

Jim, I haven't seen it for a while but I've noticed that query optimisation (Rushmore) appears to turn itself off in low memory environments, resulting in hugely slower query times. Could be that do you think?