>I have a table created by Foxpro 2.5 DOS containing about 620,000 records residing on a WinNT Server. If I run a very simple (rushmore optimizable) query using FoxPro 2.5 DOS, the time is 2.87 seconds.
>
>Running the exact same query using VFP 5.0 takes about 14 seconds.
>
>Also, when I am just opening the table "USE TABLENAME", the DOS version opens immediately, while the VFP takes about 5 seconds to open.
>
>Is the DOS version this much better? Is the problem due to the table being in an older format? What am I missing here?
>
>-Chris
Hi Chris,
I had the same problem in the past. The only solution is to create correct index files to speed up queries. Don't forget create index with expression: Deleted() and any name. After I tuned up indexes, VFP began execute queries much faster than FoxPro for DOS.
Igor Gelin
Database Developer