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.