search

rap2hpoutre / fast-excel

🦉 Fast Excel import/export for Laravel
MIT License
2.09k stars 246 forks source link

Fast? What's fast about taking 60s to read a file with 25k rows? #290

Open PINHOf opened 2 years ago

PINHOf commented 2 years ago

I have a file with 15/20 columns, 25k rows and with a length of 3.6MB. The following piece of code: $collection = (new FastExcel)->import($request->file('file')); Takes 60 seconds to execute. Tried multiple times and the execution time is always similar.

image

I was hoping to use this library to read a file with 200/300k rows.

StefanoTesla commented 2 years ago

I had the same issue, in the end I understood that the timing is just a limit in the IO of 5MB/s

Excel files are like a zip (you can extract it) and you need to read a lot of file, if you have an IO limitation on your hosting this happend, unfortunatly in this package generator are not provided