Refactoring Spring Boot Excel Import: Async Tasks, Streaming POI Parsing & SSE Progress
The article details refactoring a synchronous Spring Boot Excel import that failed at 100k rows into an async task model with streaming Apache POI SAX parsing, 500-row JDBC batch inserts, row-level error isolation, and SSE real-time progress, eliminating 504 timeouts and duplicate data on retry.
