https://issues.apache.org/bugzilla/show_bug.cgi?id=54282
Bug ID: 54282
Summary: [PATCH] Fix to speed up opening xslx spreadsheets
Product: POI
Version: 3.9-dev
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Classification: Unclassified
Created attachment 29744
--> https://issues.apache.org/bugzilla/attachment.cgi?id=29744&action=edit
Patch for avoiding repeated calls to size function
I'm seeing Apache POI being very slow when opening certain xslx/XSSF
spreadsheets. After profiling, it turns out that around half the time was spent
calling CTColsImpl.sizeOfColArray() inside ColumnHelper.addCleanColIntoCols().
See the attached screenshot from my profiler session.
The fix is trivially simple, it just pulls the call to sizeOfColArray() outside
of the loop. On some spreadsheets, this reduces the time of loading the
spreadsheet to half of the original time.
--
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]
