Maybe you could take a look and see if you can narrow down what the issues are. Then maybe you could contribute a patch?
On Fri, Jul 12, 2019 at 11:10 AM Mark Murphy <[email protected]> wrote: > I see no issue in the Bugzilla. Without an issue there, the chances of it > being worked on or even considered are poor at best. > > On Fri, Jul 12, 2019 at 9:29 AM Kirill Rajbhandary < > [email protected]> wrote: > >> Dear POI Users Group, >> >> Unfortunately I did not subscribe to POI Users List and did not get any >> information about the raised issue. >> Now I have a subscription. >> Could you please update me regarding the issue? >> >> Best regards, >> Kirill >> >> >> From: Kirill Rajbhandary >> Sent: Wednesday, 5 June, 2019 09:49 >> To: [email protected] >> Subject: POI memory usage degradation >> >> Dear POI Users Group, >> >> Unfortunately, I found out that the latest POI library poi-ooxml with >> versions 4.0.1, 4.1.0 consumes much more memory than the version 3.17 when >> it is required to write information to already existing large Excel file. >> It requires approximately 6GB Java Heap Space to add these rows using >> poi-ooxml library with version 3.17 but it is not enough even twice more >> (12GB) with version 4.0.1 or 4.1.0. Besides, the performance is much worse >> with the latest versions of poi-ooxml. OpenJDK 11.0.02 was used to run this >> example. >> In attachment the corresponding example with ExcelWriter class can be >> found that tries to add only 5 rows to already existing sheet "Sheet2" >> having only header row with 16 columns. The first sheet "Sheet1" of this >> file already contains 240K rows with 23 columns. Zipped ExcelWriter with >> Test-Template.xslx can be downloaded from the next link: >> >> https://drive.google.com/file/d/1vq6WvMv5mSFUzyJinN9aoYRBStxZuJCq/view >> >> To run ExcelWriter main method, please specify the full path to >> Test-Template.xlsx and result file path. To change poi-ooxml version, it >> requires to change it in pom.xml, rebuild the project and run it again. >> >> Could you please advise why it became worse comparing with the old >> library version poi-ooxml-3.17.jar and how it could be improved? >> >> Best regards, >> Kirill >> >> <https://www.jedox.com/de/cpm-software/testversion/> >> *www.jedox.com* <https://www.jedox.com/de/> >> Kirill Rajbhandary >> Senior Software Engineer >> *+49 761 15147 237* <+49%20761%2015147%20237> >> Jedox AG >> Bismarckallee 7a >> 79098 >> Freiburg im Breisgau >> Germany >> >> Executive Board: Florian Winterstein (Chairman), Bernd Eisenblätter, >> Maximilian Prinz zu Hohenlohe‑Waldenburg >> >> Supervisory Board: Bernhard Wöbker (Chairman), Curt Gunsenheimer, Thilo >> Schmid >> Place of Business: Amtsgericht Freiburg HRB 702118 >> >> [TM.V06112018] >> >
