[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #94 from b. <newbie-02 at gmx.de> ---

reaction on mouseclicks in files with plenty comments is painfully slow again
in 6.4 versions, 

it had been much better in 6.2, something 'regressed' from 

ver. 6.2 (tested 6.2.7.1 and 6.2.8.2), 

to 

ver. 6.4 (tested 6.4.0.1, 6.4.0.2, 6.4.0.3), 

pasting a checkerboard pattern of 4 cells (A1:B2) with different values and
comments to a 100x100 area (A1:CV100) takes about 10.9 sec. in 6.2, slightly
faster in 6.4, 

clicking a cell in that area to 'make it active' (setting the focus to that
cell) is quick and 'responsive' in 6.2, while in 6.4 it takes about two seconds
to react (sometimes you have to wait for the first save, save as, or autosave
to see the problem) ... one can! use a spreadsheet with that slow reaction, but
it's a pain in the ass, especially when you know that better performance is
possible, 

as there has been better performance i conclude it's possible, and as there are
versions with good and poor performance to compare i think it could be possible
to find the point where it evolves from ... 

(it's a minefield of performance issues around comments, comments getting lost,
moved to other cells, slow in load / save, paste, high cpu load on mousemoves,
slow reaction to clicks and so on, most other reported bugs have been closed as
duplicates of this one, thus i'm putting this info here despite it's not an
exact match of the original post)

all problems have been much better - better problems, not better performance -
in all tests i did with linux versions, thus up to now this bug is blocking my
migration from win to lin  :-( 

i'd judge this part (pasting cells with comments) of the bug 'fixed' once the
copy of a cell with comment to a full column takes less than three times the
time as for a cell without comment. actual situation is: without comment: less
than a seconds, with comments: crash ('not responding' for hours)

in reply to @Dan H from c#41: 
'Has anyone found _any_ currently-available combination of OS environment and
LO build in which the bug _can't_ be reproduced?'
win7x64 with LO 6.2.7.1 and 6.2.8.2 x64 'unpar' (unparallelized computation, no
'threaded' and no 'openCL') are the best performing versions regarding comment
slowdowns i have seen, they are not fast (as most operations are much faster on
files without or with very few comments), but they are usable, while most other
versions aren't once you have too many comments in a file ... 

(maybe with parallelized computation performance is somewhat better, but it has
unsolved bugs thus isn't yet usable for productive environments)

both problems, slowdowns when pasting commented cells and delayed reaction on
mouseclicks grow with the amount of commented cells in the file, 

reg. 

b.

-- 
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/20200217/7d57ffbb/attachment-0001.htm>