[Bug]: Got 503 Error when export to EXCEL with FromView and records greater than 20000

[kishan2030]

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?

3.1

What version of Laravel are you using?

7

What version of PHP are you using?

8

Describe your issue

class OrderExport implements FromView
{
/**
* @return \Illuminate\Support\Collection
*/
protected $orders;
protected $products;
protected $total_quantity;

public function __construct($orders, $products, $total_quantity = null)
{
    $this->orders = $orders;
    $this->products = $products;
    $this->total_quantity = $total_quantity;
}

public function view(): View
{
    if ($this->total_quantity) {
        return view('report.order_product', [
            "order_items" => $this->orders,
            "products" => $this->products,
            'total_quantity' => $this->total_quantity
        ]);
    } else {
        return view('report.orders', [
            "order_items" => $this->orders,
            "products" => $this->products
        ]);
    }
}

}

When Exporting to excel with records greater than 20000 and it provides 503 Service Unavailable error and is not able to use Queue in this.

How can the issue be reproduced?

return Excel::download(new OrderExport($new_data, $products), "Report " . $request->start_date . ' to ' . $request->end_date . ".xlsx");

What should be the expected behaviour?

File Should be downloaded

[patrickbrouwers]

If you run into timeouts/memory issues, FromView is not the right choice. Parsing the view costs a lot of time and memory and is only advised for small exports. Please use FromModel or FromCollection instead.

[patrickbrouwers]

Yes it's the same as FromCollection

[kishan2030]

got Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) this error.

[patrickbrouwers]

Depending where this happen this can be your code (querying and looping) that could me more efficient, or the amount of data just costs more memory to write to a spreadsheet. Try increasing the memory limit to 500mb.

[kishan2030]

can i use queued with collection?

[patrickbrouwers]

You can

[darkylmnx]

Hi @patrickbrouwers I have the same issue despite using FromCollection.

I have 12k rows and the following class def class CustomersExport implements FromCollection, WithHeadings and I get a response:

Request Method: GET
Status Code: 503 
Referrer Policy: strict-origin-when-cross-origin

content-length: 428
content-type: text/html; charset=iso-8859-1
date: Thu, 07 Apr 2022 01:21:10 GMT
server: Apache

What could be the issue? My memory_limit is 4G.

[patrickbrouwers]

Your apache timeout is too low

[darkylmnx]

When changing the timeout it indeed works but, for a CSV with 12k rows and a size of 1.6MB, it takes 5 to 6mins to export which can seem very long on the frontend for the user.

How come it takes so long? My server has a CPU : E5-2650vX (cpubenchmark : +13000),128G memory and an SSD disk.
If the export is queued will things still work properly?

[patrickbrouwers]

All depends how performant your logic is. Also do note that this library is made for Excel, so all those operations have an impact on csv.