poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 56705] New: [PATCH] XSSFWorkbook.getSheet(String) is slow with many sheets
Date Tue, 08 Jul 2014 16:16:41 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=56705

            Bug ID: 56705
           Summary: [PATCH] XSSFWorkbook.getSheet(String) is slow with
                    many sheets
           Product: POI
           Version: unspecified
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: cmb-apache@corefiling.co.uk

Created attachment 31802
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=31802&action=edit
patch to add a map from name to sheet

XSSFWorkbook.getSheet(String) showed up as a hot-spot in profiling, as the
project I'm on calls it very often to resolve cross-sheet formula references.

Currently it simply walks the list of sheets looking for one with a matching
name. The attached patch adds a map from name to sheet, which reduces the time
our operation spends in this method by about 80%.

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


Mime
View raw message