How Duolingo Plans to Reach 100M Users

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

Go to class Write review
DataCamp Ad

PowerBI Data Analyst - Create visualizations and dashboards from scratch

Learn More → Financial Edge Ad

The Investment Banker Certification

Learn More →

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.