LargeData | BestHub

Architecture Digest

Mar 1, 2023 · Databases

Handling Large Data Queries in MySQL with MyBatis: Regular, Stream, and Cursor Approaches

To efficiently process massive MySQL result sets without exhausting JVM memory, this article explains three query strategies—regular pagination, stream-based retrieval using MyBatis cursors, and cursor-based fetching with configurable fetchSize—detailing their implementations, advantages, and practical considerations.

CursorDatabaseLargeData

0 likes · 9 min read

Handling Large Data Queries in MySQL with MyBatis: Regular, Stream, and Cursor Approaches

Selected Java Interview Questions

Sep 4, 2022 · Backend Development

Resolving OutOfMemory Errors When Using Apache POI for Large Excel Exports

This article analyzes why Apache POI runs out of memory when writing hundreds of thousands of rows to an Excel file, examines the underlying HSSFWorkbook implementation, and demonstrates how switching to the streaming SXSSFWorkbook API provides a stable, low‑memory solution for large‑scale Excel generation.

Apache POIBackendJava

0 likes · 6 min read

Resolving OutOfMemory Errors When Using Apache POI for Large Excel Exports