I am trying to load a sql file that is 87.2GB and includes creating 37 tables and importing millions of rows of data. I selected the option to split it into multiple queries. It started out fast, but when it got over 2GB the speed of import has almost ground to a halt. It says it's imported around 30 million rows, but the time to completion keeps increasing. It currently has imported 2.5GB and shows 77 hours to finish.
I created this file by concatenating the 37 separate files together into a single file. Would it be more efficient to import each one separately?