On_delete options (CASCADE, PROTECT, SET_NULL) in Django - Performance & Optimization

Performance: On_delete options (CASCADE, PROTECT, SET_NULL)

MEDIUM IMPACT

This affects database integrity and how related data changes impact page load and interaction speed when fetching or deleting related objects.

Handling deletion of related objects in Django models

Django

class Comment(models.Model):
    post = models.ForeignKey(Post, on_delete=models.CASCADE)

# Deleting a Post automatically deletes related Comments in one operation.

CASCADE deletes related objects automatically, reducing queries and speeding up deletion.

📈 Performance GainSingle database operation reduces queries and improves interaction speed.

Handling deletion of related objects in Django models

Django

class Comment(models.Model):
    post = models.ForeignKey(Post, on_delete=models.PROTECT)

# Deleting a Post with many Comments raises errors and requires manual cleanup.

Using PROTECT blocks deletion and forces extra queries or manual cleanup, slowing down user actions.

📉 Performance CostBlocks deletion causing extra queries and user wait time, increasing INP.

Performance Comparison

Pattern	Database Queries	Deletion Blocking	Data Integrity	Verdict
CASCADE	Single query deletes related objects	No blocking	Automatic cleanup	[OK] Good
PROTECT	Multiple queries to check constraints	Blocks deletion	Prevents accidental loss	[! ] OK
SET_NULL	Single query sets foreign key to null	No blocking	Preserves dependent data	[OK] Good

Rendering Pipeline

When deleting or updating related objects, Django triggers database operations that affect server response time and client rendering speed.

→Database Query

→Server Processing

→Client Rendering

⚠️ BottleneckDatabase Query due to multiple or blocked deletions

Core Web Vital Affected

INP

This affects database integrity and how related data changes impact page load and interaction speed when fetching or deleting related objects.

Optimization Tips

1Use CASCADE to delete related objects automatically and reduce queries.

2Avoid PROTECT if you want smooth deletions without blocking user actions.

3Use SET_NULL to keep related data without deleting it, improving data stability.

Performance Quiz - 3 Questions

Which on_delete option automatically deletes related objects to reduce extra queries?

A CASCADE

B PROTECT

C SET_NULL

D DO_NOTHING

DevTools: Network

How to check: Open DevTools, go to Network tab, perform deletion action, and observe number and timing of API/database calls.

What to look for: Look for multiple or delayed requests indicating blocking or extra queries affecting interaction speed.