Better Eloquent Performance

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

Autoplay

Previous: About the Course: What's Inside? Next Lesson: N+1 Query: "Deeper" Examples - Packages and Count

Chris C

4 months ago

So we came from 31 queries done in 11.6 ms to 2 queries done in 23.53 ms? Can you please clarify this? Greetings Povilas, thanks for all the work you do!

Povilas Korop

4 months ago

Hm, interesting catch, never really looked from that angle, I went for minimizing the queries. Perhaps for more realistic scenarios, for bigger databases, the time for those 31 queries would be much longer.

Better Eloquent Performance

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?