LuTiao Programming
Nov 12, 2026 · Backend Development
SQL 300ms, API 12s: The Hidden Cost of Returning 100k Records to Frontend
A backend query interface took 12 seconds despite a 300ms SQL query because it returned 100,000 records directly to the frontend, causing massive object creation, JSON serialization, memory spikes, and GC pressure; the fix involved pagination, DTO projections, separate export endpoints, and monitoring response size.
Async ExportDTO ProjectionGC Pressure
0 likes · 18 min read