>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?

I think the APPEND FROM command needs more speed (this is for Microsoft)..

I remember having a procedure for appending 1-300 records to a 10MB table with an APPEND FROM command. It tooks 20 minutes to finish the process. The table has 6 indexes.

And then I write a pair of SQL commands, that loads the two tables (the temporary + the final), and then write it down to disk, in the same command. Then, rename the files and create the indexes. It was amazing: just 20 seconds ..!!

I don't think using this in a 250 MB file.

Why don't you try the INSERT INTO command ?
I change all my code (in the FPW days..) from APPEND BLANK to INSERT INTO, in a Novell environment.

The APPEND/REPLACE tooks 4 secs for appending 1 record, and the INSERT INTO tooks 2.6 secs (in my olddd machine).

Try to append the 10,000 recs using INSERT INTO commands.