mardi 6 février 2018

How can Handle 1 million records using Laravel and MySQL?

We are developing job portal website here by around 1 million users is there. most of the time export excel options showing timeout error. We are trying to increase the execution time also but still occurring timeout issue.

I need experts suggestions. thanks in advance.

$report = User::where('status',1)->get();

Excel::create('report -'.time(), function($excel) use ($report) {
    $excel->sheet('report-excel', function($sheet) use ($report)
    {
        $sheet->loadView('admin.report-excel',array('reports'=>$report));
    });
})->download('xls');

`



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire