poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Murphy <jmarkmur...@gmail.com>
Subject Re: POI memory usage degradation
Date Fri, 12 Jul 2019 15:12:24 GMT
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 <jmarkmurphy@gmail.com> 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 <
> kirill.rajbhandary@jedox.com> 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: user@poi.apache.org
>> 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]
>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message