https://issues.apache.org/bugzilla/show_bug.cgi?id=54593

--- Comment #3 from Dominik Stadler <[email protected]> ---
Created attachment 30346
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=30346&action=edit
Screnshot showing where most of the time is spent

I did a quick performance analysis using dynaTrace, it seems really the
underlying XML handling is causing this behavior. It seems XSSFCellBorder calls
toString() on the CTBorder element both in hashCode() and equals(). The call is
done a large number of times and every time causes XML Text to be generated for
the border-element, so almost all the exeuction time of the test case is spent
somewhere in there.

So yes, using HSSF instead of XSSF would probably speed it up considerably.
Otherwise some caching might help, but for this I still lack details of POI to
see if it would be possible. I assume the real issue is in the
openformats-framework that is used by POI which seems to have an expensive
toString() implementation.

-- 
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]

Reply via email to