Bug 57042 - Writing Large Excel Sheet (~150K rows) causing the api to dump large xml file at /tmp dir. Also does not compress & cleanup up causing the /tmp/ disk space full
Summary: Writing Large Excel Sheet (~150K rows) causing the api to dump large xml file...
Status: RESOLVED WORKSFORME
Alias: None
Product: POI
Classification: Unclassified
Component: SXSSF (show other bugs)
Version: 3.10-FINAL
Hardware: HP Linux
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-09-29 17:36 UTC by Tapas
Modified: 2015-08-16 12:55 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Tapas 2014-09-29 17:36:19 UTC 
We have set workbook window size to -1 // -1 turn off auto-flushing and Called workbook.dispose();
Also called workbook.setCompressTempFiles(true);

But still we see huge file (few GB) created at /tmp dir - when we tried to write ~ 142 K Excel rows. 
Causing the /tmp FS to full.
Comment 1 Nick Burch 2014-09-29 17:39:27 UTC 
Please try with 3.11 beta 2 - does that help?
Comment 2 Dominik Stadler 2015-08-16 12:55:58 UTC 
No update for a long time, therefore closing this as WORKSFORME for now, please reopen if this is still a problem for you.