Insert 1 milion record

I second the use of mysql's load data infile. I worked on a project once where they with dealing with millions of rows of data reqularly, with data normalization, etc. We handled that by using load data to load the CSV to a temporary table at which point we could removed duplicates, normalize, etc. before merging into the rest of the working data. Worked pretty well.

Support Development •  CodeIgniter 4 Foundations • Practical CodeIgniter 3  • CodeIgniter Tutorials