FutureWeb
1 year ago

Insert all data from temp table without looping

Posted 1 year ago by FutureWeb

Hiya LaraPeeps,

I have a number of temp tables which huge amounts of data are imported into using some custom artisan commands.

these run as jobs a couple of times a day I want to copy everything from the temp to live tables as quickly as possible with as little load as possible, one table contains up to 6.5 million records.

temp and live tables are identical.

I am after something like an insert using a sub select:

INSERT INTO live_table (SELECT * FROM tmp_table)

Any help or advice would be greatly appreciated.

Please sign in or create an account to participate in this conversation.