[Libreoffice-bugs] [Bug 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon at bugs.documentfoundation.org]

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

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

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

--- Comment #22 from b. <newbie-02 at gmx.de> ---
Created attachment 165379
  --> https://bugs.documentfoundation.org/attachment.cgi?id=165379&action=edit
file with macro to test 'comment performance' in LO calc,

it gets better gradually, but the processing of comments in calc is still a
huge problem,  

i have attached a sheet with a small macro, it should be self-explanatory,
fresh loaded you likely have to activate the form control toolbar via [view -
toolbars - form controls] and deactivate 'edit mode' there, otherwise the macro
button won't work, 

with '1' and '0' in A2 and A3 you can time the generation of 10.000 cells
without comments, and with '1' and '1' the time for the same with comments, 

with higher numbers in A2 more cells are created and it takes longer, 

i find that 1 second for 150.000 and 4 seconds for 2.000.000 cells without
comments, compared to 411 seconds for 150.000 cells with comments, shows that
the handling of comments in calc is still 'not very effective' ... 

the problem gets much worse after the first (auto-)save, the memory usage is
more than doubled after that, maybe this is an indication, 

similar delays occur in the handling of 'normal' files with many comments, to
one of the many threads about it someone had attached a Lenovo article list
with 25.000 comments, useless for everyday work :-(

-- 
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/20200910/1bf67db1/attachment.htm>