Fast insert

I need to do insert a lot of data into a table and need to improve
performance. I don't think DTS is adequate since I'm not simply
copying/transforming existing data but rather computing it as I go. I think
transaction logging is an extra cost that I should avoid, but I'm already
using simple recovery mode... What are other possible optimizations?Have your appliation write each computed record to a tab delimited text file
residing on the local HD and having the same column format as the table.
Once done, bulk copy the file into the destination table. Also, it may help
to drop indexes prior to the load and re-create them afterward.
[url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx[/u
rl]
"Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
news:3E700E7B-0983-4DB7-BCAF-BC862C2AEB9A@.microsoft.com...
>I need to do insert a lot of data into a table and need to improve
> performance. I don't think DTS is adequate since I'm not simply
> copying/transforming existing data but rather computing it as I go. I
> think
> transaction logging is an extra cost that I should avoid, but I'm already
> using simple recovery mode... What are other possible optimizations?