<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Memory usage goes through the roof saving document with 120k of comments"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131675">bug 131675</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>newbie-02@gmx.de
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Memory usage goes through the roof saving document with 120k of comments"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131675#c8">Comment # 8</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Memory usage goes through the roof saving document with 120k of comments"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131675">bug 131675</a>
from <span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span></b>
<pre>Hello @Telesto, Roman and Julien,
thanks for taking care for this problem,
it is quite old and often discussed, see bugs: 131675 131672 129228 128402
127758 125619 125545 124692 123418 119650 119636 119075 114377 113599 106433
106385 105888 105499 97698 88194 76324 60418 56268 54563 54018 34519 and some
more ...
it is one of the bigger general problems besides
- copy and paste,
- autocalc / shared formulas / threading / openCL,
- iterative calculations, and
- floating point precision,
that are probably difficult to solve.
'comments' is linked to 'copy/paste' somewhere in the drawing layer, where
things have been specially arranged to allow clipboard pasting even if the
source file has been closed in the meantime?
Noel has already taken care of this problem and in
<a class="bz_bug_link
bz_status_NEW "
title="NEW - FILESAVE: It takes >2:40 to save a small spreadsheet with comments and more than 400Mb in extra memory usage (because laying out the text for each caption 3 times)"
href="show_bug.cgi?id=119650#c11">https://bugs.documentfoundation.org/show_bug.cgi?id=119650#c11</a> he said: 'this
is what I could do...', and pinpoints the problem.
best progress I know: 6.2.7.1 and 6.2.8.2 - win - are comparatively good,
catchwords I picked up:
'non linear transformation between grid and display',
'non linear transformation between grid and pointing device - accelerated
moves',
drawing layer (memory?) is registered by some obscure stuff,
'layout for captions / annotations / notes / comments / tracking notes is done
three times',
A suspicion I have, some things in calc are processed 'from bottom to top, then
right to left', but the comments are stored in the files (and in memory?) from
left to right, then top to bottom ... an iteration 'calculate the space for
<a href="show_bug.cgi?id=131675#c10">comment 10</a> - you need the space for <a href="show_bug.cgi?id=131675#c9">comment 9</a> - calculate the space for comment
9 - you need 8 ... need 1 ... then coming to 9, again calculating 8 ...1, and
so on ... would lead to the fact that the calculation time would increase with
every further comment (don't know how many times) ... but such a thing
increases unneccessarily ...
[SUM(n = 1 to k+1: n*(n+1)/2)) instead of k+1 calculations for comment k+1???
observations look more like n*(n+1)/2]</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>