How to export 100,000 plus data?

[jeromevillaver]

If my data (rows) is below 10,000 it's downloadable but beyond that number of rows it prompt an error

[

2023-10-24 06:36:31] local.ERROR: Allowed memory size of 268435456 bytes exhausted (tried to allocate 4096 bytes) {"userId":16,"exception":"[object] (Symfony\\Component\\ErrorHandler\\Error\\FatalError(code: 0): Allowed memory size of 268435456 bytes exhausted (tried to allocate 4096 bytes) at /var/www/admin-backend/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php:3318)
[stacktrace]
#0 {main}
"} 

any recommendations?

This is my current code

class PvpExport implements FromQuery, WithStyles, WithHeadings, ShouldAutoSize, WithChunkReading
{
    use Exportable;
    use RemembersChunkOffset;

    private string $writerType = Excel::XLSX;

    protected $startDate;
    protected $endDate;
    protected $mode;

    public function __construct($startDate, $endDate, $mode)
    {
        $this->startDate = $startDate;
        $this->endDate = $endDate;
        $this->mode = $mode;
    }

    public function query()
    {
        $query = Pvp::select(
            'id',
            'match_id',
            'player_id_1',
            'player_id_2',
            'winner_id',
            'room_id',
            'type',
            'rake',
            'player_1_level_1_id',
            'player_1_level_2_id',
            'player_2_level_1_id',
            'player_2_level_2_id',
            'player_1_level_1_commission',
            'player_1_level_2_commission',
            'player_2_level_1_commission',
            'player_2_level_2_commission',
            'gold_reward',
            'mmr',
            'mmr_enabled',
            'ends_at',
            'disbursement_completed_at',
            'waiting_time'
        )
            ->when($this->mode !== 'all', function ($query) {
                return $query->where('type', $this->mode);
            })
            ->when($this->startDate && $this->endDate, function ($query) {
                return $query->whereDate('created_at', '>=', $this->startDate)
                    ->whereDate('created_at', '<=', $this->endDate);
            });

        return $query;
    }

    public function headings(): array
    {
        return [
            'ID',
            'Match ID',
            'Player ID 1',
            'Player ID 2',
            'Winner ID',
            'Room ID',
            'Type',
            'Rake',
            'Player 1 Level 1 ID',
            'Player 1 Level 2 ID',
            'Player 2 Level 1 ID',
            'Player 2 Level 2 ID',
            'Player 1 Level 1 Commission',
            'Player 1 Level 2 Commission',
            'Player 2 Level 1 Commission',
            'Player 2 Level 2 Commission',
            'Gold Reward',
            'MMR',
            'MMR_enabled',
            'Ends At',
            'Disbursement Completed At',
            'Waiting Time',
        ];
    }

    public function styles(Worksheet $sheet)
    {
        return [
            1 => ['font' => ['bold' => true]],
        ];
    }

    public function chunkSize(): int
    {
        return 1000; // Adjust the chunk size as per your needs
    }

}

[jeromevillaver]

I was able to resolved it by adding ini_set('memory_limit', '1G'); in the construct of the export file

the code

public function __construct($sortBy, $orderBy, )
   {
       $this->sortBy = $sortBy ?? 'id';
       $this->orderBy = $orderBy ?? 'desc';

       ini_set('memory_limit', '1G');

       // dd($sortBy, $orderBy);

   }

The reason I add it in the export file constructor is that I don't want the whole application to take big memory consumptions. It will just take memory consumption when the download is clicked.

But if you have better Idea you can share it here.

[jeromevillaver]

just add ini_set('memory_limit', '1G'); in the constructor

public function __construct($sortBy, $orderBy, )
   {
       $this->sortBy = $sortBy ?? 'id';
       $this->orderBy = $orderBy ?? 'desc';

       ini_set('memory_limit', '1G');

       // dd($sortBy, $orderBy);