DO NOT REPLY [Bug 15716] [RFE] reduce memory consumption

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=15716


Josh Micich <jo...@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |RESOLVED
         Resolution|                            |FIXED




--- Comment #9 from Josh Micich <jo...@gildedtree.com>  2008-10-30 13:41:35 PST ---
It seems (see bug 45570) that the biggest offender for hssf memory usage is all
the exploded Formulas (Ptg arrays).  Depending on the content of the workbook,
the Ptgs could account for up to half the JVM heap usage (of the HSSFWorkbook
object graph).

I made a change in svn 709235 to convert (almost) all Ptg arrays into Formula
objects which only spill their Ptg tokens when asked.  Large savings were
gained by converting formula un-sharing from eager to lazy.

I ran some tests on a local XLS file (around 4MB in size, containing around
35,000 formula cells).  Before the change, this file took 28.1MB when loaded by
POI.  After the change it took 22.6MB.


There is still a long way to go.  No doubt there will be additional requests to
reduce POI's memory footprint.  Please supply example XLS files with any new
requests (preferably in a new Bugzilla), so we can focus on the specifics, and
track progress better.


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org