Laravel – Speed of Running Eloquent

If you call repeatedly relationship model attributes, it will affects to response speed. Because laravel will connect database and tables whenever you call relationship model attributes.

So, in this case, you must build one SQL for getting all available attributes from all relationship models.

For example:

@foreach ($posts as $post)
   {{ $post->author->fullName }}
@endforeach

This is not professional way and it will speed down to render time because laravel will connect db for counts of $posts.

$posts = DB::table('posts')->select('author.fullName as authorName', 'posts.*')->leftJoin('author', 'posts.author_id', '=', 'author.id');

---------------------------------
@foreach ($posts as $post)
   {{ $post->authorName }}
@endforeach

This code will speed up to get full data and render page than above case code.