Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
Hi, Need to make excel report of data using laravel. Its crashing every-time whenever i try to export data with more entries. I have around 30 million data in a table. Memory limit set is 128KB
you're definitely going to crash your application if you are trying to output that many rows at once.
You should look at writing your csv in 'chunks'.
Look at the following for selecting with chunks. https://laravel.com/docs/9.x/queries#chunking-results
and an example (not very new) of getting chunked data into a csv https://barryvdh.nl/laravel/2015/02/07/streaming-large-csv-files-with-laravel-chunk/
Curious, why so much? Could you let the database do the work of the report then export the summaries.
What time frame does the report cover. I would normally do monthly, then combine some monthly reports into a quarterly.
@jlrdw Could you let the database do the work of the report then export the summaries.
what exactly you mean?
Also make sure to do it in a command or job. Never do a task like this in a HTTP request
Please or to participate in this conversation.