Polymorphic relationships in Laravel - Performance & Optimization

Performance: Polymorphic relationships

MEDIUM IMPACT

This affects database query performance and page load speed by influencing how many queries and joins are executed.

Fetching related models using polymorphic relationships

Laravel

Post::with('comments')->get();

Eager loading fetches all related comments in a single query, reducing database calls.

📈 Performance GainSingle query for posts and comments, reducing queries from N+1 to 2.

Fetching related models using polymorphic relationships

Laravel

Post::all()->each(fn($post) => $post->comments);

This triggers the N+1 query problem by running one query for posts and one query per post for comments.

📉 Performance CostTriggers N+1 queries, increasing database load and slowing page rendering.

Performance Comparison

Pattern	DOM Operations	Reflows	Paint Cost	Verdict
Lazy loading polymorphic relations	Minimal DOM impact	Minimal	Minimal	[X] Bad - causes multiple queries delaying content
Eager loading polymorphic relations	Minimal DOM impact	Minimal	Minimal	[OK] Good - reduces queries and speeds data availability

Rendering Pipeline

Polymorphic relationships affect the data fetching stage before rendering. Complex queries or multiple queries delay data availability, impacting the time to render content.

→Data Fetching

→Rendering

→Layout

⚠️ BottleneckData Fetching due to multiple or complex queries

Core Web Vital Affected

LCP

This affects database query performance and page load speed by influencing how many queries and joins are executed.

Optimization Tips

1Avoid lazy loading polymorphic relations in loops to prevent N+1 queries.

2Use eager loading with 'with()' to fetch related models efficiently.

3Index polymorphic keys in the database to speed up queries.

Performance Quiz - 3 Questions

What is the main performance issue with lazy loading polymorphic relationships in Laravel?

A It increases CSS rendering time

B It causes many database queries (N+1 problem)

C It blocks JavaScript execution

D It increases image download size

DevTools: Network and Performance panels

How to check: Open DevTools, go to Network tab, filter XHR requests to see database API calls; use Performance tab to record page load and check for delays caused by multiple queries.

What to look for: Look for many small API calls indicating N+1 queries and long data fetching times delaying content rendering.