https://bz.apache.org/bugzilla/show_bug.cgi?id=70139
Bug ID: 70139
Summary: Performance issues when inserting new rows
Product: POI
Version: 5.5.x-dev
Hardware: PC
Status: NEW
Severity: major
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 40195
--> https://bz.apache.org/bugzilla/attachment.cgi?id=40195&action=edit
Test what is measuring insert row perfomances
We noticed significant change in performance between poi 4.0.1 and poi 5.4.1
(or any other poi 5 version) when we are inserting new rows. This is especially
visible when we are working with sheets that contain several thousands of rows.
Seems like shifting rows and rebuilding them is slower then before. I am
attaching small test that demonstrates what I am talking about.
Here is quick stat when you compare versions 4.01 and 5.4.1:
Average insertRows (poi 5.4.1): 10 817.330 ms
Average insertRows (poi 4.0.1): 31.518 ms
//build.gradle
dependencies {
implementation 'org.apache.poi:poi-ooxml:4.0.1'
//implementation 'org.apache.poi:poi-ooxml:5.4.1'
testImplementation("junit:junit:4.13")
testImplementation 'org.junit.jupiter:junit-jupiter:5.10.2'
testRuntimeOnly 'org.junit.platform:junit-platform-launcher'
}
--
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]
