You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2009/11/16 13:05:10 UTC
DO NOT REPLY [Bug 48205] New: POI 3.5 Memory and perfomance solution
https://issues.apache.org/bugzilla/show_bug.cgi?id=48205
Summary: POI 3.5 Memory and perfomance solution
Product: POI
Version: 3.5-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: dev@poi.apache.org
ReportedBy: nisharg@gmail.com
Hi,
As directed by David, posting as a bug entry.
This project does not contain Unit test cases, but I have created a small
stand-alone program. If needed unit test cases can be created, but that depends
upon my availability.
Forum Entry can be found at :
http://old.nabble.com/POI-3.5-Memory-and-perfomance-solution-td26313991.html
For Reference:
--------------
This is continuation of thread at below location:
http://old.nabble.com/Memory-and-perfomance-issues-td25990601.html
We have extended Yegor's BiggridDemo and provided some more features. I have
attached approach document for attached eclipse project. This project also
contains ready to run program (ExcelDemo.java).
This solution does not cover 100% of Excel features but targets most of the
sweet spots.
We would like to know how best we can utilize this code in POI.
Note: ooxml-schemas-1.0.jar, xmlbean-2.3.0.jar and poi-3.5-beta7-20090602.jar
files are not included in eclipse project due to file size limitation. Please
provide the files in classpath.DemoProject.zip
--
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
DO NOT REPLY [Bug 48205] POI 3.5 Memory and perfomance solution
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48205
--- Comment #3 from Petr.Udalau <Pe...@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.
Results:
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
DO NOT REPLY [Bug 48205] POI 3.5 Memory and perfomance solution
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48205
neurons <ad...@bankofamerica.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |adithya.neelavara@bankofame
| |rica.com
--
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
DO NOT REPLY [Bug 48205] POI 3.5 Memory and perfomance solution
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48205
--- Comment #2 from Jaydeep <ni...@gmail.com> 2009-11-17 01:05:37 UTC ---
Created an attachment (id=24548)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24548)
Approch document, to give more infomation about solution.
--
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
DO NOT REPLY [Bug 48205] POI 3.5 Memory and perfomance solution
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48205
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #5 from Yegor Kozlov <ye...@dinom.ru> 2011-06-16 15:32:03 UTC ---
Since 3.8-beta3, POI provides a low-memory footprint SXSSF API built on top of
XSSF.
See
http://poi.apache.org/spreadsheet/index.html
and
http://poi.apache.org/spreadsheet/how-to.html#sxssf
Yegor
--
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
DO NOT REPLY [Bug 48205] POI 3.5 Memory and perfomance solution
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48205
--- Comment #1 from Jaydeep <ni...@gmail.com> 2009-11-16 04:14:15 UTC ---
Hi,
Because of the size limitation DemoProject.zip can not be attached here. Please
download it from forum entry.
Jaydeep.
--
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
DO NOT REPLY [Bug 48205] POI 3.5 Memory and perfomance solution
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48205
Pavithra <sp...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P2 |P1
Severity|normal |critical
--
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
DO NOT REPLY [Bug 48205] POI 3.5 Memory and perfomance solution
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48205
Nick Burch <ni...@alfresco.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P1 |P2
Severity|critical |normal
--- Comment #4 from Nick Burch <ni...@alfresco.com> 2010-08-25 07:01:42 EDT ---
Please do not randomly change priorities without offering useful input
If this bug is critical to you, please submit patches that improve things, or
get a budget to sponsor someone to code the patches
--
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