Slide 62
Slide 62 text
Eloquent ORM
Normal Usage
$posts = Post::all();
foreach ($posts as $post)
{
echo $post->user->email;
}
100 posts = 101 queries
!
SELECT * FROM "posts"
!
foreach result {
SELECT * FROM "users" WHERE "id" = 1
}
Eager Loading
$posts = Post::with(‘user’)->get();
foreach ($posts as $post)
{
echo $post->user->email;
}
100 posts = 2 queries
!
SELECT * FROM "posts"
!
SELECT * FROM "users" WHERE "id" IN (1, 2, 3, 4, 5, ...)