Bug 60498 - [PATCH] XSSFImportFromXML Performance for large XML
Summary: [PATCH] XSSFImportFromXML Performance for large XML
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.14-FINAL
Hardware: PC All
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords: PatchAvailable
Depends on:
Blocks:
 
Reported: 2016-12-19 15:40 UTC by Daniel
Modified: 2017-01-03 16:53 UTC (History)
1 user (show)


Attachments
Patch that solves a performance issue when Importing large xml (1.40 KB, application/x-gzip)
2016-12-19 15:40 UTC, Daniel 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Daniel 2016-12-19 15:40:39 UTC 
Created attachment 34535 [details]
Patch that solves a performance issue when Importing large xml

When using XSSFImportFromXML to import a large XML (several 1000 data entries) into tables, the Duration of this Operation increases exponential.

The reason for that is a Performance issue in the Evaluation of xpath. (Read more here: http://stackoverflow.com/questions/3782618/xpath-evaluate-performance-slows-down-absurdly-over-multiple-calls

Find attached Patch.
Comment 1 David North 2017-01-03 15:41:54 UTC 
Thanks, patch and test look good to me.

Fixed in SVN r1777146