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 2016/11/24 21:13:37 UTC
[Bug 60416] New: Reduce Hyperlink memory consumption in SXSSF
https://bz.apache.org/bugzilla/show_bug.cgi?id=60416
Bug ID: 60416
Summary: Reduce Hyperlink memory consumption in SXSSF
Product: POI
Version: unspecified
Hardware: PC
OS: All
Status: NEW
Severity: enhancement
Priority: P2
Component: SXSSF
Assignee: dev@poi.apache.org
Reporter: onealj@apache.org
Target Milestone: ---
From
https://lists.apache.org/thread.html/b59a525b6a4dbea9de4d138952c0ab2629c528423f19b363d3434452@%3Cuser.poi.apache.org%3E
Subject: Too much memory is used by a hyperlink in a spreadsheet
Author: Dmitry Katsubo
Memory consumption can be reduced by delaying when new CTHyperlink objects are
created until writing the hyperlinks out to <hyperlinks> after <sheetData/> in
<worksheet>.
--
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 60416] Reduce Hyperlink memory consumption in SXSSF
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60416
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |mattdatascientist@gmail.com
--- Comment #4 from Dominik Stadler <do...@gmx.at> ---
*** Bug 60723 has been marked as a duplicate of this bug. ***
--
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 60416] Reduce Hyperlink memory consumption in SXSSF
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60416
--- Comment #2 from Javen O'Neal <on...@apache.org> ---
Update SXSSF how-to.html to mention that hyperlinks may use a lot of memory in
r1771233.
--
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 60416] Reduce Hyperlink memory consumption in SXSSF
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60416
--- Comment #5 from Dominik Stadler <do...@gmx.at> ---
Simple code-sample from the duplicated bug:
-example code:
SXSSFWorkbook wb = new SXSSFWorkbook(100);
SXSSFSheet sheet = wb.createSheet();
CreationHelper createHelper = wb.getCreationHelper();
Hyperlink link;
SXSSFRow row;
SXSSFCell cell;
for(int i=0; i<1000000; i++){
row = sheet.createRow(i);
cell = row.createCell(1);
cell.setCellValue("Click Me");
link = createHelper.createHyperlink(Hyperlink.LINK_URL);
link.setAddress("http://yoururl.com");
cell.setHyperlink(link);
}
//then code to write to file.
--
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 60416] Reduce Hyperlink memory consumption in SXSSF
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60416
--- Comment #1 from Javen O'Neal <on...@apache.org> ---
Applied Dmitry's patch from email (with modification) in r1771231.
--
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 60416] Reduce Hyperlink memory consumption in SXSSF
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60416
Dmitry <dm...@mail.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |dma_k@mail.ru
--- Comment #3 from Dmitry <dm...@mail.ru> ---
The patch is just a minor drop into the sea… more fundamental solution is
needed. As complete solution also involves other objects like comments and
regions, perhaps the ultimate goal is difficult to achieve. However I think
that hyperlinks are potentially used mostly. Javen, what kind of workarounds do
you think are feasible at the moment?
--
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