Bug 50320 - Opening .xlsx file cosumes large memory space
Summary: Opening .xlsx file cosumes large memory space
Status: RESOLVED WONTFIX
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.7-FINAL
Hardware: PC Windows Server 2003
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-11-22 23:01 UTC by chentao
Modified: 2010-11-23 07:06 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 chentao 2010-11-22 23:01:06 UTC 
Hi,

When I open a .xlsx file in POI is see a lot of instance of class org.apache.xmlbeans.impl.store.Xobj. 
They take up a large space in the JVM( compare to the .xls file ).
Is it a bug in the memory usage when parsing OOXML files?
Or it is just a different in the implementation when parsing old and new excel files?
Comment 1 Nick Burch 2010-11-23 07:06:24 UTC 
The XSSF UserModel needs more memory than the equivalent HSSF one, because it's XML based rather than records, and that uses more. If memory is a real issue, you'll want to do SAX based processing. http://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api details how