poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 48205] POI 3.5 Memory and perfomance solution
Date Mon, 23 Nov 2009 10:54:29 GMT

--- Comment #3 from Petr.Udalau <Petr.Udalau@exigenservices.com> 2009-11-23 02:54:25
UTC ---
As I understood main idea is to use common classes(Cell, Sheet, Workbook) for
HSSF and XSSF and use Mappers(or Writers) to save workbook into needed format.
It will be suitable because parsing and saving HSSFWorkbook and XSSFWorkbook
takes different memory and process resources.

In addition it will good for evaluation. 
I created simle test with sheet that contains big number of formulas and run it
with profiler. Test contains parsing of workbook and evaluaion of all formulas
two times.


Step                     HSSF     XSSF

Parsing:               10735ms   19859ms
The First Evaluation:   5046ms   18234ms
The Second Evaluation:   485ms     922ms

Methods of formula parsing(during the First Evaluation) and getting type of
cell(during the Second Evaluation) takes most of time.

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

View raw message