Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Eloquent Performance Patterns

Go to class Write review

Boot.dev

Stuck in Tutorial Hell? Learn Backend Dev the Right Way

DataCamp

Power BI Fundamentals - Create visualizations and dashboards from scratch

Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Unlock All Certificates

In this series, you'll learn how to drastically improve the performance of your Laravel applications by pushing more work to the database, all while still using the Eloquent ORM. This course is a culmination of everything I've learned along my journey, distilled into a single course. We're going to dig deep into advanced real world problems.

Syllabus

Techniques

Measuring Your Database Performance
Minimize Memory Usage
Getting One Record From a Has-Many Relationship
Dynamic Relationships Using Subqueries
Calculate Totals Using Conditional Aggregates
Optimize Circular Relationships

Search Feature

Multi-Column Searching
Getting LIKE to use an Index
Faster Options Than whereHas
When it Makes Sense to Run Additional Queries
Use Unions to Run Queries Independently
Fuzzier Searching With Regular Expressions

Performance

Run Authorization Policies in the Database
Faster Ordering With Compound Indexes
Options for Ordering by a HasOne Relationship
Options for Ordering by a BelongsTo Relationship
Options for Ordering by a HasMany Relationship
Options for Ordering by a BelongsToMany Relationship
Ordering With NULLs Always Last
Ordering By Custom Algorithms
Filtering and Sorting Anniversary Dates
Make N+1 Issues Impossible
Ordering Data For Humans Using Natural Sort
Full Text Searching With Rankings
Get the Distance Between Geographic Points
Filter by Geographic Distance
Order by Geographic Distance
Filter by Geospatial Area

Taught by

Jonathan Reinink

Reviews

Start your review of Eloquent Performance Patterns