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.