Skip to content
Tagged articles

Async Export

2 articles · Page 1 of 1
LuTiao Programming
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
SQL 300ms, API 12s: The Hidden Cost of Returning 100k Records to Frontend
Su San Talks Tech
Su San Talks Tech
Feb 7, 2024 · Backend Development

How to Build an Asynchronous Excel Export System in Java

This guide explains how to design a robust asynchronous Excel export feature in Java, covering thread pools, task persistence, interceptor annotations, handling large datasets, multi‑sheet output, custom headers, WebSocket notifications, retry mechanisms, and code‑generation utilities.

Async Exportjob scheduling
0 likes · 6 min read
How to Build an Asynchronous Excel Export System in Java