Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <dev@poi.apache.org>
From: bugzilla@apache.org
To: dev@poi.apache.org
Subject: [Bug 60397] very slow Cell Merge for SXSSFWorkbook
Date: Tue, 09 May 2017 16:54:01 +0000
Message-ID: <bug-60397-47293-L9RAKQyclz@https.bz.apache.org/bugzilla/>
In-Reply-To: <bug-60397-47293@https.bz.apache.org/bugzilla/>
References: <bug-60397-47293@https.bz.apache.org/bugzilla/>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Auto-Submitted: auto-generated
MIME-Version: 1.0
archived-at: Tue, 09 May 2017 16:54:07 -0000

https://bz.apache.org/bugzilla/show_bug.cgi?id=3D60397

Stephen Webster <stephen.webster@inetsoft.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--- Comment #5 from Stephen Webster <stephen.webster@inetsoft.com> ---
I have been watching this bug, and wanted to add some information that I ha=
ve
gathered since I didn't see any progress.  Here is my testcase.

for(int i=3D0; i < 20000; i++) {
   for(int j=3D0; j < 30; j+=3D3) {
      CellRangeAddress range =3D new CellRangeAddress(i,i,j,j+2);
      sheet.addMergedRegionUnsafe(range);
   }
}

The results get quite a bit worse as the number of rows/merged region number
increases.

1000  rows -> 1.2 seconds
10000 rows -> 100 seconds
20000 rows -> Over 5 minutes.

I dropped the above code and profiled it and turns out the time spent is in=
 the
return statement of addMergedRegion(), ctMergeCells.sizeOfMergeCellArray();

I am not using the return value of this method, after creating a locally
modified version of the XSSFSheet class, I created a method without the ret=
urn
statement and the testcase finishes in less then 1 second instead of over 5
minutes for 20,000 rows.

Here is the stack from profiler which was 90% of time spent
Stack Trace
org.apache.xmlbeans.impl.store.Locale.count(Xobj, QName, QNameSet)
org.apache.xmlbeans.impl.store.Xobj.count_elements(QName)=20=20=20=20=20=20=
=20
org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTMergeCellsImpl.s=
izeOfMergeCellArray()
org.apache.poi.xssf.usermodel.XSSFSheet.addMergedRegion(CellRangeAddress,
boolean)
org.apache.poi.xssf.usermodel.XSSFSheet.addMergedRegionUnsafe(CellRangeAddr=
ess)

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