Is there a workable solution to importing large datasets into a DB in server connect?

[mebeingken]

Have a look at this

Slow insert records into the database

Using LOAD DATA INFILE would be the fastest way to import bulk data from an csv. Doing an insert for each data record will be very slow when importing such a large dataset, it is already faster to do a bulk insert using INSERT INTO, but that also would not be able to do 50k records at once.