Bug 55699 - Memory leakage issue in POI 3.9 version
Summary: Memory leakage issue in POI 3.9 version
Status: RESOLVED LATER
Alias: None
Product: POI
Classification: Unclassified
Component: SXSSF (show other bugs)
Version: 3.9-FINAL
Hardware: Other Windows XP
: P2 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-10-24 10:26 UTC by CTcreations
Modified: 2014-09-05 18:59 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description CTcreations 2013-10-24 10:26:47 UTC
I have used Apache POI for creating .xlsx files. I tried with POI 3.8 version but it has the memory leakage issue(It creates temp files and take large amount of time to create excel file). Now I am using POI 3.9 version, but it also shows the memory leakage issue same as in 3.8 version. I tried to retrieve 10000 records from DB and creates Excel file, It took around one hour time to create the file. 

Is there any new function or new package available in 3.9 version for resolving the memory leakage issue??
Comment 1 Nick Burch 2013-10-24 10:35:06 UTC
Are you using XSSF or SXSSF? Are you sure that the delay is really in POI, and not (say) in your code that talks to the database? Are you sure you really mean a "memory leak", and not (say) just high memory use during the file creation?
Comment 2 CTcreations 2013-10-24 10:45:23 UTC
yeah..I am using SXSSF. What I mean by Memory leakage is it creates temporary XML file and keep increasing the size while running the program and at last it deleted (am using Dispose() function) and it took huge amount of time to create excel file. I am using the same code that is used in 3.8 version. My database accessibility is very fast, I don't think that db access is the problem. Do I need to change any function or any other thing in my code??
Comment 3 CTcreations 2013-10-24 10:46:23 UTC
yeah..I am using SXSSF. What I mean by Memory leakage is it creates temporary XML file and keep increasing the size while running the program and at last it deleted (am using Dispose() function) and it took huge amount of time to create excel file. I am using the same code that is used in 3.8 version. My database accessibility is very fast, I don't think that db access is the problem. Do I need to change any function or any other thing in my code??
Comment 4 Nick Burch 2013-10-24 10:50:11 UTC
SXSSF is supposed to create temporary files and add to them as you write more rows, that's how it works!
Comment 5 CTcreations 2013-10-24 11:03:43 UTC
So how to reduce my excel file creation time? Is that possible?
Comment 6 CTcreations 2013-10-24 11:33:04 UTC
Can I reduce the time taken for creating Excel file in 3.9v??
Comment 7 Nick Burch 2013-10-24 11:40:47 UTC
You'll need to tell us where the time is going before we can help you.... Try running a profiler against it to work out what's taking the time
Comment 8 CTcreations 2013-10-24 11:57:28 UTC
yeah... I will do that. Before that Can you please tell me , 3.8v and 3.9v is only difference is the jar files...rite?? I have replaced only the old jar files and put new jar files.No additional function added in 3.9v..rite??
Comment 9 Nick Burch 2013-10-24 12:00:07 UTC
Full changelog is on the website - http://poi.apache.org/changes.html#3.9
Comment 10 Andreas Beeker 2014-09-05 18:59:35 UTC
No feedback over 1 year now ... I'm closing this now ...