Courses

Better Eloquent Performance

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

Lesson 18/21 · 4:55 min

Autoplay

Repository for this lesson

Previous: Faster Seeds with Insert and Chunk

Hammud El hammud

1 year ago

Hello, thanks for nice tutorial... I would ask what if we make a mapper class to mapping this categories then aggregating products to categories then return the collection with some keys (products_count) instead of doing it in blade ? thanks in advance ..

Povilas Korop

1 year ago

Maybe, I haven't tried with this example.

Better Eloquent Performance

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

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?