PHP
Prevent N+1 Queries with Eloquent Eager Loading
Optimize your Laravel application's performance by learning how to eagerly load related models using `with()` in Eloquent, effectively preventing the N+1 query problem.
// Bad practice (N+1 problem)
// $users = App\Models\User::all();
// foreach ($users as $user) {
// echo $user->posts->count() . "
"; // Each call executes a new query
// }
// Good practice (Eager Loading)
$usersWithPosts = App\Models\User::with('posts')->get();
foreach ($usersWithPosts as $user) {
// Accessing $user->posts now uses data already loaded
echo "User: {$user->name}, Posts Count: {$user->posts->count()}
";
foreach ($user->posts as $post) {
echo "- {$post->title}
";
}
}
How it works: The N+1 query problem occurs when fetching a collection of models and then iterating over them to access a relationship on each model, leading to N+1 database queries (one for the parent models and N for the related models). This snippet shows how to solve this using Eloquent's `with()` method for eager loading. By specifying `'posts'` with `with('posts')`, Laravel loads all related posts for all users in a single additional query, drastically improving performance.