[Libreoffice-bugs] [Bug 125545] performance issue caused by comments?

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #10 from b. <newbie-02 at gmx.de> ---
sorry for continuing here, the other thread is too long that anybody will read
through it ... 

three observations: 

1.) high cpu load is already triggered on hovering with the mouse / touchpad
through the screen , you need not click anywhere, 

2.) it is also triggered while hovering over an empty area of the screen,
without any data or comments inside or belonging to the visible cells, 

3.) things behave better - significantly better but far far away from fine! -
when you save the file as 'fods', (Flat XML ODF spreadsheet), it's using plenty
time the disk space but produces fewer delays / hangs / crashes or can handle
singnificantly more cells and comments than with compression normally used for
the file, 

one assumption: !!! it is only an assumption !!! 

might it be the case that comments are implemented as something like a 'one way
referenced list', not having them inside the structure of the cells, but as a
'separate list', and with references which comment belongs to which cell only!
in that list, but not having a reference at the cells where to look for the
related comment? 

would be 'bad programming practice', even worse if the list is not sorted. 

that could explain plenty issues to me, everthing will work well while you have
no or few comments, it's already a waste of ressources to check through that
list on every mousemove, but it's done quickly and nobody complains about, once
you have too many comments you have to check a long list ... on every
mousemove!!! because you miss the path 'from coordinate to knowledge' and do a
time consuming search instead, once the saved format is compressed that becomes
very cpu-load-intense ... 

and one thought beyond the normal view: 

this issue is an ecological mess!!! besides wasting the time of plenty users in
plenty plenty plenty little slices it's producing plenty plenty plenty plenty
unneccessary cpu load on every mousemove of every calc user worldwide working
in a file with commenst! and that wastes small but measureable pieces of
energy, and plenty plenty plenty of them do! have an impact on global energy
waste and thus contribute to ecological problems and climate change ... 

just my two cents, anybody laughing at me because he knows better ... should
not laugh!!! - but share his knowledge where theese annoying performance
impacts result from.

-- 
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/20190530/b8f25cb3/attachment.html>