CRUD operations through models in Ruby on Rails - Performance & Optimization

Performance: CRUD operations through models

MEDIUM IMPACT

This affects how quickly data changes reflect on the page and the server response time during create, read, update, and delete actions.

Performing database updates inside a loop without batching

Ruby on Rails

Model.where(id: records.map(&:id)).update_all(attribute: new_value)

This sends a single query to update all records at once, reducing database calls and speeding response.

📈 Performance Gainsingle database query; reduces server processing time significantly

Performing database updates inside a loop without batching

Ruby on Rails

records.each do |record|
  record.update(attribute: new_value)
end

This triggers a separate database query for each record, causing many round-trips and slowing response.

📉 Performance Costblocks rendering for multiple milliseconds per query; triggers many server requests

Performance Comparison

Pattern	DOM Operations	Reflows	Paint Cost	Verdict
Multiple individual updates in loop	Minimal DOM changes but delayed	0 (server-side delay)	Low paint cost but delayed update	[X] Bad
Batch update_all query	Minimal DOM changes but faster	0 (server-side delay)	Low paint cost with faster update	[OK] Good

Rendering Pipeline

CRUD operations through models affect the server response time, which delays when the browser receives updated HTML or JSON. This impacts the time before the user sees updated content or can interact again.

→Server Processing

→Network Transfer

→DOM Update

⚠️ BottleneckServer Processing due to multiple or inefficient database queries

Core Web Vital Affected

INP

This affects how quickly data changes reflect on the page and the server response time during create, read, update, and delete actions.

Optimization Tips

1Avoid updating records one by one; batch updates reduce server queries.

2Minimize callbacks during bulk operations to speed up processing.

3Use efficient queries to reduce server response time and improve interaction speed.

Performance Quiz - 3 Questions

What is the main performance problem with updating records one by one in a loop?

A It causes many separate database queries, increasing server response time.

B It causes the browser to repaint multiple times unnecessarily.

C It increases the size of the HTML sent to the browser.

D It causes layout shifts on the page.

DevTools: Network

How to check: Open DevTools, go to Network tab, perform the CRUD action, and observe the number and duration of requests to the server.

What to look for: Look for multiple similar requests indicating inefficient queries or a single quick request indicating optimized batch operations.