I have the following eloquent relation
User Model
public function supplies()
{
    return $this->hasMany('App\Supply', 'employee');
}
Supply Model
public function user()
    {
        return $this->belongsTo('App\User', 'employee');
    }
    public function projects()
    {
        return $this->belongsTo('App\Project', 'project');
    }
Project Model
public function supplies()
{
    return $this->hasMany('App\Supply', 'project');
}
I try to get all supplies per year on projects with the following query
$supplies = Project::with('supplies')->whereHas('supplies', function ($query){
           $query->with('user.skills')->where('deleted', 0)->whereIn('supply_status', [1,2])->whereYear('time_from', 2017);
        })->orderBy('title')->get();
supplies table has lot of entries and I have memory limit problems. How can I optimize to get the best result?
via Chebli Mohamed
 
Aucun commentaire:
Enregistrer un commentaire