I had an application written in FoxPro for Windows. I converted the system to VFP 3.0b. Everyday, we add about 10,000 records from one table to another. The destination table is about 250 meg and has 5 regular indexes. In the old system, this process took about 5 to 10 minutes. Now it takes almost an hour. This append process is running on a Pentium Pro 200 with 32 meg under Windows NT 4.0. While running the performance monitor, I noticed that CPU was ver low and so was network I/O. There are two differences between the old system and the new one: In the old system, the desination table had only one index. Also, the tables were opened exclusively. Now they are opened shared so that other users can continue working.
Any ideas?