ShouldQueueWithoutChain for Exports

[jayceedaily]

I am using laravel vapor and I am having issues exporting an excel file with a million rows. The problem is that the chained job that is created runs so long that it timesout the lambda. The problem with chained jobs is that it is treated as a single job on lambda hence hitting the limit. Would it be possible to change this behavior in a way that the array of the chained job will be passed on an AppendQueryToSheet, and once that job is done, it will then dispatch another AppendQueryToSheet with one less item on the chained job list. This way it will not hit the 15 minute limit of lambda since it will create a new instance of lambda everytime it finishes.

Current
Lambda 1 - [ AppendQueryToSheet(1) > AppendQueryToSheet(2) > AppendQueryToSheet(3) ]

Proposed
Lambda 1 - AppendQueryToSheet([1,2,3])
Lambda 2 - AppendQueryToSheet([2,3])
Lambda 3 - AppendQueryToSheet([1])

[patrickbrouwers]

It already exists: ShouldQueueWithoutChain

[jayceedaily]

ShouldQueueWithoutChain only works with import if I am not mistaken?

[patrickbrouwers]

Ah sorry exports you meant. I personally wouldn't use the append query to sheet anymore, every job gets longer and longer because it has to rewrite all previous rows; so literally no point of using a chain anymore and will be deprecated in 4.x.
Probably best to wrap it in a job of your own and let that queue run for max 15 minutes.