Can't import excel with 2 millions rows mysql laravel?

Viewed 697

I can't import mysql data with 2 million rows at the moment I can only import 8500 data.If I am over 8500 it will appear

" 503 Service Unavailable The server is temporarily busy, try again later! "

enter image description here

<?php

namespace App\Imports;
use App\Models\{Datalead,Debitur,Perusahaan,Saldolist};


use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\{ToCollection, WithHeadingRow, WithCalculatedFormulas,WithMultipleSheets };

class DataleadImportSaldolist implements ToCollection, WithHeadingRow, WithCalculatedFormulas,WithMultipleSheets 
{
    /**
    * @param Collection $collection
    */

    public function sheets(): array
    {
        return [
            0 => $this,
        ];
    }
    public function collection(Collection $collection)
    {
        //print("<pre>".print_r($collection,true)."</pre>");
        foreach ($collection as $row) 
        {

                    $saldo = Saldo::create([

                        'Tanggal' => $row['tanggal'],
                        'KodeCab' => $row['kode_cab'],
                        'NamaCab' => $row['nama_cab'],
                        'KodeKLN' =>$row['kodekln'],
                        'SentraKode'=> $row['sentra_code'],
                        'KodeKCP' => $row['kodekcp'],
                        'AccountType' => $row['account_type'],
                        'SubCategory' => $row['sub_category'],
                        'Produk' => $row['produk'],
                        'Peruntukan' => $row['peruntukan'],
                        'Currency' =>  $row['currency'],
                        'Kurs' => $row['kurs'],

                    ]);
        }        
    }
}
1 Answers
Related