You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/10/24 12:26:47 UTC
[Bug 55699] New: Memory leakage issue in POI 3.9 version
https://issues.apache.org/bugzilla/show_bug.cgi?id=55699
Bug ID: 55699
Summary: Memory leakage issue in POI 3.9 version
Product: POI
Version: 3.9
Hardware: Other
OS: Windows XP
Status: NEW
Severity: critical
Priority: P2
Component: SXSSF
Assignee: dev@poi.apache.org
Reporter: ctvipin007@gmail.com
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??
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55699] Memory leakage issue in POI 3.9 version
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55699
CTcreations <ct...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #3 from CTcreations <ct...@gmail.com> ---
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??
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55699] Memory leakage issue in POI 3.9 version
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55699
--- Comment #5 from CTcreations <ct...@gmail.com> ---
So how to reduce my excel file creation time? Is that possible?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55699] Memory leakage issue in POI 3.9 version
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55699
--- Comment #7 from Nick Burch <ap...@gagravarr.org> ---
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
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55699] Memory leakage issue in POI 3.9 version
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55699
CTcreations <ct...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--- Comment #2 from CTcreations <ct...@gmail.com> ---
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??
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55699] Memory leakage issue in POI 3.9 version
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55699
--- Comment #4 from Nick Burch <ap...@gagravarr.org> ---
SXSSF is supposed to create temporary files and add to them as you write more
rows, that's how it works!
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55699] Memory leakage issue in POI 3.9 version
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55699
Andreas Beeker <an...@gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |LATER
--- Comment #10 from Andreas Beeker <an...@gmx.de> ---
No feedback over 1 year now ... I'm closing this now ...
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55699] Memory leakage issue in POI 3.9 version
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55699
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
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?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55699] Memory leakage issue in POI 3.9 version
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55699
--- Comment #6 from CTcreations <ct...@gmail.com> ---
Can I reduce the time taken for creating Excel file in 3.9v??
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55699] Memory leakage issue in POI 3.9 version
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55699
--- Comment #9 from Nick Burch <ap...@gagravarr.org> ---
Full changelog is on the website - http://poi.apache.org/changes.html#3.9
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55699] Memory leakage issue in POI 3.9 version
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55699
--- Comment #8 from CTcreations <ct...@gmail.com> ---
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??
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org