Laravel: MASSIVE updateOrCreate()

I am trying to export data (nightly) out of an archaic system into something that's a little bit easier to write code for; however, the amount of data being exported is MASSIVE.

I am dumping the data as JSON objects and then trying to updateOrCreate() using Laravel, but I have way too much data. It usually takes about 10 hours to process all of the data into the 2.5 MILLION MySQL rows.

I think it is slow because it is actually performing 5 MILLION queries.

Does anyone know of any good example on how efficiently execute a MASSIVE updateOrCreate() using Laravel?

via Chebli Mohamed