[Libreoffice-bugs] [Bug 131675] Memory usage goes through the roof saving document with 120k of comments

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131675

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |newbie-02 at gmx.de

--- Comment #8 from b. <newbie-02 at gmx.de> ---
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
https://bugs.documentfoundation.org/show_bug.cgi?id=119650#c11 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
comment 10 - you need the space for comment 9 - 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]

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200426/696f9e6c/attachment.htm>