lundi 24 octobre 2016

How can I speed this Eloquent Query up?

The following query is retrieving a large data set (~25k rows). It is running very slowly, and I would like to know how to speed it up:

$jobs = Job::whereArchived(true)->get();

    foreach ($jobs AS $job)
    {
        $rows[] = [
            "<a href='/admin/projects/jobs/$job->id'>{$job->name}</a>",
            $job->start_date ? $job->start_date : "Not Specified",
            $job->end_date ? $job->end_date : "Not Specified", 
            $job->agent ? $job->agent->name : "Unassigned",
            $job->status ? $job->status : "Not Specified"

        ];
    }
echo Html::table()
    ->head($headers)
    ->body($rows)
    ->datatable();

This particular query / result is taking around 60 seconds to complete at least. How can I speed this up?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire