Laravel Excel and time-outs
Greetings,
I have large dataset that needs to be exported to excel. I switched from FromView implementation to FromQuery to chunk my data.
I use columnFormats to provide certain formatting to cell positions,
headings to provide a Heading row,
the query which is the standard implementation of FromQuery and
map in order to match cell positions under the correct heading columns.
It correctly dispatches multiple Jobs, called AppendQueryToSheet. Where I get error is the last job, CloseSheet.
Allowed memory size of 536870912 bytes exhausted (tried to allocate 16777224 bytes)
Has anyone encountered the exact same scenario? (I can't be the only one). I can't believe that this package has fore-seen the scenario with large datasets (hence the FromQuery), but CloseSheet handles everything in single job
Thanks in advance
Please or to participate in this conversation.