My Page Takes 3-5 Whole Minutes To Load, How Can I Possibly Reduce It?

I'm currently working on this project and the main page takes nearly 5 whole minutes to load. I've been trying to reduce the runtime, but I'm still new to programming and I'm not t

Solution 1:

It's definitely because of N+1 problem. Learn how to use eager loading.

You're creating a lot of redundant queries to the DB inside the loop, probably thousands instead of just 6.

Eloquent can "eager load" relationships at the time you query the parent model. Eager loading alleviates the N + 1 query problem.

https://laravel.com/docs/5.5/eloquent-relationships#eager-loading