[Bug 57884] New: XSSFDataFormat.getFormat is slow with large numbers of formats

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 57884] New: XSSFDataFormat.getFormat is slow with large numbers of formats

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=57884

            Bug ID: 57884
           Summary: XSSFDataFormat.getFormat is slow with large numbers of
                    formats
           Product: POI
           Version: 3.12-dev
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: [hidden email]
          Reporter: [hidden email]

As discovered when working on #57880, for XSSF, creating 33,000 cell styles is
30 times faster than creating the same number of format indexes. For 5,000 cell
styles and formats, creating the cell styles is only 3 times faster than
creating the formats.

--
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 57884] XSSFDataFormat.getFormat is slow with large numbers of formats

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=57884

--- Comment #1 from Nick Burch <[hidden email]> ---
In r1677368 I've made a few changes which gives a 3x speed improvement on
creating 33,000 data formats in XSSF. It's still slower to create the formats
than it is to create cell styles, so there may be some more optimisations to do

--
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 57884] XSSFDataFormat.getFormat is slow with large numbers of formats

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=57884

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|normal                      |enhancement

--
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 57884] XSSFDataFormat.getFormat is slow with large numbers of formats

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=57884

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|                            |57880


Referenced Bugs:

https://bz.apache.org/bugzilla/show_bug.cgi?id=57880
[Bug 57880] Writing negative cellStyleIndex into sheet1.xml
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]