[Bug]: Huge exports doesn't work

[bucalexis]

Is the bug applicable and reproducable to the latest version of the package and hasn't it been reported before?

• Yes, it's still reproducable

What version of Laravel Excel are you using?

9

What version of Laravel are you using?

9

What version of PHP are you using?

8.1

Describe your issue

When I try to export 100K users the export doesn't finish

How can the issue be reproduced?

• Generate a database with 100k users (default laravel users table)
• Create a from query export class for the users
• Use the laravel QUEUE_CONNECTION=database
• Run the exporter with the ->queue option

What should be the expected behaviour?

The export should be generated

[patrickbrouwers]

Better to create an own queue job and do an Excel::store in there. (The chunked queuing has performance issues, because phpspreadsheet has to re-read the entire file on each chunk) I'm able to export way more than 100k that way.

[lachie-92]

What do you mean do an Excel::store in there? Where do you do the excel::store?

[patrickbrouwers]

Literally move everything you have in the controller to a queue job you create yourself (instead of Excel::queue use Excel::store)