Inserting Millions of Rows from another table

Faster way to insert rows into a table from a select statement and insert into?

Insert into PartyMain
Select [PermID]
      ,[IsOptOut]
      ,[UpdatedOn]
开发者_Python百科      ,[FK_DataSource]
 From PartyMain

with 6M rows is taking > 4 minutes

insert via select is the fastest way i can think of to insert data. You might be able make improvements in you app work flow, however.

I imagine have some sort of button in an app that kicks off the process. Instead of doing the insert when a user tells the app to (Im making that assumption), can you have a process that runs every X seconds that does the transfer? Or alternatively check every X seconds and if the number of rows to transfer is greater than Y, run the transfer...So in other words, dont wait until there are 6 million rows.

Edit- another options might be database triggers.

Do you have any indexes on PartyMain? If yes, you may want to

1. Drop Indexes
2. Insert Rows
3. Recreate Indexes

that might improve the performance.

Also - are you sure you reading from PartyMain and Inserting into PartyMain?