Better Eloquent Performance

Detect and Prevent N+1 Query: With Package or Laravel 8.43+

Lesson 05/21 · 2:55 min

Autoplay

Previous: Eager Loading with load() and $with

Ghiath Al-Khatib

2 years ago

hello thank you for this course, I am trying to implement this code "preventLazyLoading" but the query "$user->posts " is executed without the errors. I have written the same code in the article https://laravel-news.com/disable-eloquent-lazy-loading-during-development I can't catch error LazyLoadingViolationException I looked at https://laravel.com/docs/master/eloquent-relationships#lazy-eager-loading and I couldn't prevent lazy loading. Do you have an idea about this laravel v9.19

Povilas Korop

2 years ago

Not sure, I can't "blindly" guess what you did wrong. Maybe your environment is production, that's why preventing doesn't work?

Better Eloquent Performance

Detect and Prevent N+1 Query: With Package or Laravel 8.43+

About the Course: What's Inside?

What is N+1 Query: Typical Example, Debugbar and Eager Loading

N+1 Query: "Deeper" Examples - Packages and Count

Eager Loading with load() and $with

Detect and Prevent N+1 Query: With Package or Laravel 8.43+

With() VS WithCount(): Out of RAM Memory?

Aggregation: withAvg(), withMin() and withMax()

Example Demo: Teachers and Students Dashboards

Select Only What You Actually Need

Collections: filter(), map() or DB Query?

API Return: Kilobytes Optimization

Be Careful with Eloquent Accessors and Foreach

Eloquent vs Query Builder: whereHas vs join() vs Raw SQL

Example Demo: whereHas vs join() on DEEPER relationships

SubQueries and SubSelects: One Step Towards Raw SQL

Query Result Caching: With or Without Package

Faster Seeds with Insert and Chunk

E-Shop with Three-Level Categories: Tree and Product List

E-Shop with Unlimited Subcategory Levels

Using Nested Set Package for Unlimited Subcategory Levels

What if Your Queries are Still Slow?