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 2019/05/16 09:17:18 UTC
[Bug 63443] New: Writing a large spreadsheet 4x slower after
upgrading to 4.0+
https://bz.apache.org/bugzilla/show_bug.cgi?id=63443
Bug ID: 63443
Summary: Writing a large spreadsheet 4x slower after upgrading
to 4.0+
Product: POI
Version: 4.0.0-FINAL
Hardware: Macintosh
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: thomasvanputten@hotmail.com
Target Milestone: ---
Whilst upgrading from 3.17 to 4.1.0 we experienced a severe reduction in the
performance of writing a larger spreadsheet we have in our application.
3.17 took ~4 seconds
4.1.0 took 17-20 seconds (same for 4.0.0 and 4.0.1)
After doing some digging it turned out XSSFRow.java onDocumentWrite method
started using a lot more CPU time now.
This eventually led to us looking at this patch r1825277
It looks like this performance optimisation was removed intentionally as part
of bug #62130
Is there a way around this significant performance penalty?
As it's likely to be deemed unacceptable for our users.
--
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
[Bug 63443] Writing a large spreadsheet 4x slower after upgrading to
4.0+
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63443
--- Comment #1 from PJ Fanning <fa...@yahoo.com> ---
The previous optimisation appeared to cause problems in some cases.
Feel free to submit a patch if you can get an implementation working that
doesn't break the existing tests.
Another option is to use SXSSFWorkbook for writing your file as this
implementation doesn't have the XMLBean overhead (at the cost of reduced
capabilities).
--
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
[Bug 63443] Writing a large spreadsheet 4x slower after upgrading to
4.0+
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63443
Thomas van Putten <th...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |LATER
--- Comment #2 from Thomas van Putten <th...@hotmail.com> ---
Thank you for your explanation, we're unlikely to find time to submit a patch
soon but now we at least know what's up.
--
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
[Bug 63443] Writing a large spreadsheet 4x slower after upgrading to
4.0+
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63443
Bob van den Berge <bo...@seoduct.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
CC| |bob@seoduct.com
--
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