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