>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?
both of those changes will affect performance, but i don't think it will affect performance that much. are both files located on the server? it's possible that the system is pulling the info to append to the final table to the machine you're calling this method from and then sending it back...