BestHub
Sign in
Top Architect
Top Architect
Feb 28, 2021 · Backend Development

Optimizing Large Excel Import Performance in Java Backend Applications

This article details a step‑by‑step optimization of a Java backend Excel import pipeline, covering migration from POI to EasyExcel, caching database lookups, batch insertion with MySQL VALUES, and parallel processing to reduce a 100k‑row import from minutes to under two minutes.

ExcelJavaMyBatis
0 likes · 10 min read
Optimizing Large Excel Import Performance in Java Backend Applications
Architecture Digest
Architecture Digest
Sep 15, 2020 · Databases

Optimizing Large‑Scale Excel Import in Java: From POI to EasyExcel, Caching, Batch Inserts and Parallel Processing

This article details how to dramatically speed up Excel‑driven fee‑record imports by replacing naïve POI row‑by‑row processing with EasyExcel, caching database look‑ups, using MySQL batch INSERTs, and finally applying parallel streams for multi‑threaded insertion, while also trimming excessive logging.

EasyExcelExcelJava
0 likes · 12 min read
Optimizing Large‑Scale Excel Import in Java: From POI to EasyExcel, Caching, Batch Inserts and Parallel Processing