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

Laracasts

Eloquent Performance Patterns

via Laracasts

Overview

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.