laravel relationship eager loading code example

Example 1: laravel eager loading where clause

$query = ""    

if ($request->has('country'){
$query = Post::with("country")->whereHas("country",function($q) use($request){
    $q->where("name","=",$request->country);
})->get()
}else{
    $query = Post::with("country")->get();
}

Example 2: eager loading vs lazy loading c#

When to use eager loading

In "one side" of one-to-many relations that you sure are used every where with main entity. like User property of an Article. Category property of a Product.
Generally When relations are not too much and eager loading will be good practice to reduce further queries on server.
When to use lazy loading

Almost on every "collection side" of one-to-many relations. like Articles of User or Products of a Category
You exactly know that you will not need a property instantly.
Note: like Transcendent said there may be disposal problem with lazy loading.

Tags:

Php Example