When is denormalization acceptable for performance?

Question

Accepted Answer

Denormalization Duplicate data to speed reads—counters, summary tables, JSON blobs. Accept update complexity and consistency lag. Read-heavy dashboards Caching order totals Eventual consistency via jobs Always say measure first—indexes often enough.