https://issues.apache.org/bugzilla/show_bug.cgi?id=51171
Bug #: 51171
Summary: [PATCH] Performance opening large XLS-Files
(InternalWorkbook.getStyleRecord)
Product: POI
Version: 3.8-dev
Platform: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
Created attachment 26970
--> https://issues.apache.org/bugzilla/attachment.cgi?id=26970
Patch against SVN trunk
Opening ~5M XLS-Files takes about half a second and high CPU load.
By a quick profiling I discovered a 55-million-times loop for getting the user
style name for my XLS-files.
This patch against trunk fixes the number of loops significantly, by fixing the
'iterative search' causing the high loop count.
I'll attach the profiling details in a moment.
As a summary, for my test cases I measured an average speedup = old_time /
new_time = ~ 1.3 .
Would be great if the patch could be included in the next 3.8 release.
Cheers,
Marcel
--
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: [email protected]
For additional commands, e-mail: [email protected]
