Allowed memory size of 268435456 bytes exhausted (tried to allocate 16777248 bytes)

[jeromevillaver]

I got this error

Allowed memory size of 268435456 bytes exhausted (tried to allocate 16777248 bytes)

even if I add PHP_MEMORY_LIMIT=2G this in .env

<?php

namespace App\Exports;

use App\Models\Player;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithMapping;

class PlayerExport implements FromCollection, WithMapping
{

    public function collection()
    {
        return Player::all();
    }

    public function chunk()
    {
        return 10;
    }


    public function map($player): array
    {
        return [
            $player->name,
            $player->email,
            $player->username,
            $player->minerals,
            $player->experiences,
            $player->energies,
            $player->referral_points,
            $player->mmr,
            $player->golds,
        ];
    }

}

controller

  public function export()
    {
        return Excel::download(new PlayerExport, 'users.xlsx');
    }

[patrickbrouwers]

You are loading your entire Player::all() data in memory, that is probably too much for PHP to handle within 2GB. Use FromQuery instead and it should already improve a bit.

[jeromevillaver]

I change the code into this..

    public function export()
    {
        return Excel::download(new PlayerExport, 'users.xlsx');
    }

<?php

namespace App\Exports;

use App\Models\Player;
use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Concerns\Exportable;

class PlayerExport implements FromQuery
{
    use Exportable;

    public function query()
    {
        return Player::select('id', 'name', 'email', 'username', 'minerals', 'experiences', 'energies', 'referral_points',
        'mmr', 'golds');
    }


}

but I don't have download output or nothing happend after I clicked the button