Geek asks and answers

Insert millions of rows from another table

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

Insert into PartyMain
Select [PermID]
      ,[IsOptOut]
      ,[UpdatedOn]
      ,[FK_DataSource]
 From PartyMain

with 6M lines takes> 4 minutes

+3
source share
2 answers

insert via select is the fastest way I can think of to insert data. However, you may be able to improve the application.

, - , . , , ( ), , X , ? , , X , Y, ... , , , 6 .

- .

+1

- PartyMain? ,

.

, PartyMain PartyMain?

0
source

More articles:


All Articles