>Hi all
>
>I got 2 .txt file with information delimited with ";" to append in 2 table.
>I use append from to append the information but it's not to fast I think
>
>For the fisrt table 492 record are append and for the second one 3635 record are append it take arround 26 second for both tables.
>
>Is it me or it's not very fast.
>How can I speed or what can slow done the "append from "
>
>
>Thanks and have a nice week end
>
>
>Benoit
Benoit,
Append from is fast and 26 seconds is not acceptable for such little reccounts (-unless it's a pentium-kidding:).
If there are too many indexes it slows down the append for they should be updated. Create a routine that would remove indexes and put back after append.
Cetin