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

This has not been my experience. In general the append from command adds about 100 records per second on my machine (Pentium 60 MHz with 16 MB RAM)
One tip is to make sure you set all indexes off first with the

SET ORDER TO

command. Otherwise the index is updated after each record is added and the time slows down dramatically. Insert into is definitely the way to go to add 1-2 records etc but for bulk adding append from works fine.

HTH