What you would learn in Better Eloquent Performance course?
In the case of slow Laravel websites or applications, the top "popular" cause is related to lengthy queries. There are either too many queries or excessive data loaded with them or another cause.
Therefore, for this class, I decided to collect all the information I have learned about the art of eloquence into simple, practice lessons.
In just 20 lessons, you will be able to tackle the most commonly encountered situations, and you'll have access to 14 repository sites that you can explore and play with.
Course Content:
Intro
- Preview About the Course: What's Inside?
N + 1 Query Problem
- Preview What is N + 1 Query: Typical Example, Debugbar, and Eager Loading
- Preview N + 1 Query: "Deeper" Examples - Packages and Count
- Start Eager Loading with load() and $with
- Start to Detect and Prevent N + 1 Query: With Package or Laravel 8.43+
Optimizing RAM Consumption
- Start With() VS WithCount(): Out of RAM Memory?
- Start Aggregation: withAvg(), withMin() and withMax()
- Start Example Demo: Teachers and Students Dashboards
- Start Select Only What You Actually Need
- Start Collections: filter(), map() or DB Query?
- Start API Return: Kilobytes Optimization
Optimizing CPU and Queries: Make the Database Work
- Start Be Careful with Eloquent Accessors and Foreach
- Start Eloquent vs. Query Builder: whereHas vs. join() vs. Raw SQL
- Start Example Demo: whereHas vs. join() on DEEPER relationships
- Start SubQueries and SubSelects: One Step Towards Raw SQL
- Start Query Result Caching: With or Without Package
- Start Faster Seeds with Insert and Chunk
Relationships to the Same Table
- Start E-Shop with Three-Level Categories: Tree and Product List
- Start E-Shop with Unlimited Subcategory Levels
- Start Using Nested Set Package for Unlimited Subcategory Levels
What's Next
- Start What if Your Queries are Still Slow?
Download Better Eloquent Performance from below links NOW!
