poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 54282] New: [PATCH] Fix to speed up opening xslx spreadsheets
Date Tue, 11 Dec 2012 17:52:04 GMT

            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: dev@poi.apache.org
          Reporter: jan.stette@gmail.com
    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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message