How to import CSV 300k rows in Laravel?

Question

PHP

I am using laravel-excel lib.
Network file of 130 MB and 300k lines, you need to add it to the database.
I decided to do it through queues, but the problem is that when I load this file, the sled read does not work and, accordingly, does not add it to the database.
If you upload a file with fewer lines, then everything works.
How can I download such a file?

Answer 1

umm.... why do you need laravel-excel to import csv?
take the package from the league and read line by line. I import them millions of lines every day, without any queues.
https://csv.thephpleague.com/

Answer 2

If you upload a file with fewer lines, then everything works.

Read into memory not the entire file at once, but for example 10k lines. But in general, csv is just a text file (this is to the fact that excel and csv are very different inside). with a separator between lines, you can write your own solution, which will not be difficult to implement