sql - Inserting Millions of Rows from another table -

faster way insert rows table select statement , insert into?

insert partymain select [permid]       ,[isoptout]       ,[updatedon]       ,[fk_datasource]  partymain 

with 6m rows taking > 4 minutes

insert via select fastest way can think of insert data. might able make improvements in app work flow, however.

i imagine have sort of button in app kicks off process. instead of doing insert when user tells app (im making assumption), can have process runs every x seconds transfer? or alternatively check every x seconds , if number of rows transfer greater y, run transfer...so in other words, dont wait until there 6 million rows.

edit- options might database triggers.