Eager Loading vs Lazy Loading with API Resource

Question

Could you please suggest which option I should use for the following example.

I'm currently building an API to get Places, Place model contains User and Location models.

Relationships are set like that:

class Place extends Model
{
    protected $guarded = [];

    public function createdBy()
    {
        return $this->belongsTo(User::class, 'created_by', 'id');
    }

    public function location()
    {
        return $this->belongsTo(Location::class);
    }
}

Option 1: Lazy Loading:

public function getPlaces()
{
    return Place::all()->get();
}

class PlaceResource extends JsonResource
{
    public function toArray($request)
    {
        return [
            'id' => $this->id,
            'createdBy' => (new UserResource($this->createdBy)),
            'location' => (new LocationResource($this->location)),
        ];
    }
}

Option 2: Eager Loading:

public function getPlaces()
{
    return Place::with([
        'createdBy',
        'location',
    ])
    ->get();
}

class PlaceResource extends JsonResource
{
    public function toArray($request)
    {
        return [
            'id' => $this->id,
            'createdBy' => (new UserResource($this->createdBy)),
            'location' => (new LocationResource($this->location)),
        ];
    }
}

Logically thinking with the Eager Loading option data should loads quicker, right? I have tested both options for about 100 places but the loading time seems to be the same.

What's the right way (option to use) to load data quicker?

lagbox · Accepted Answer · 2020-09-20 15:39:47Z

1

It is better to Eager Load those relationships when dealing with a result set like that. Since you are iterating through each record in that result set and accessing the relationship this would cause a N+1 issue otherwise. Since it is 2 relationships being accessed it would be (N*2) + 1 .

edited Sep 20, 2020 at 15:39

answered Sep 20, 2020 at 15:29

lagbox

50.7k8 gold badges76 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Eager Loading vs Lazy Loading with API Resource

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related