You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2015/05/03 09:36:08 UTC

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

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: dev@poi.apache.org
          Reporter: apache@gagravarr.org

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

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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=57884

Dominik Stadler <do...@gmx.at> changed:

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

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

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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=57884

Dominik Stadler <do...@gmx.at> 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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=57884

--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org