[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 --- Comment #102 from David John --- But not all comments are negative,https://phrazle.io/ some people love writing for CALC and it’s a great opportunity to share your content with the world. Let’s face it. https://weaverwordle.com/weaver-game -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 Buovjaga changed: What|Removed |Added Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #101 from Buovjaga --- I tested with attachment 96007 and opening takes about 14 secs stopwatch time on my Win 10 virtual machine. attachment 123072 takes 3 secs to open. attachment 125689 takes 16 secs to open and 50 secs to save. Let's finally close this as fixed and keep it that way. This report was already too long in 2018 and now it's high time to move on. There are other reports mentioned in the comments and See Also that likewise should be re-tested. Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 1638b4f78af70b7b97d0a081ed51390dd87bf1f9 CPU threads: 2; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: fi-FI (fi_FI); UI: en-US Calc: threaded Jumbo -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC||79045_79...@mail.ru --- Comment #100 from Roman Kuznetsov <79045_79...@mail.ru> --- in Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: e4d23c27288b99c3ed3cfa332ff308b31c01f97d CPU threads: 4; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: ru-RU (ru_RU.UTF-8); UI: en-US Calc: threaded Jumbo I opened the example https://bugs.documentfoundation.org/attachment.cgi?id=96007 for 10 sec only Cope/paste the cells with comments is just instantly Someone please retest it in latest master build too please -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 --- Comment #99 from srd...@email.cz --- *** Bug 138151 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 --- Comment #98 from b. --- i think i have isolated and visualized one of the 'most evil' aspects / effects of this bug in: https://bugs.documentfoundation.org/show_bug.cgi?id=125619#c23 may be it's worth to have a look there ... -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 Xisco Faulí changed: What|Removed |Added Keywords|dataLoss| -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 Xisco Faulí changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||5619 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 b. changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||1674 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 Julien Nabet changed: What|Removed |Added CC||er...@redhat.com --- Comment #97 from Julien Nabet --- Eike: thought you might be interested in this one since it concerns Calc and there are several duplicates. If needed, I can generate other Flamegraph graphs with different renderings. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 b. changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=11 ||9075 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 --- Comment #96 from b. --- @Telesto and @Timur, summary: calc has 'comment issues', similar is affecting 'tracking notes' and comments in writer, slow reaction (click delays), slow load / save, unnecc. cpu load, high mem usage, high cpu load on mousemoves, immense mem usage after autosave / save as ... even system freezes and crashes, acc. to @Noel it's resulting from unproductive work done for the 'drawing layer', see c#85, maybe this patch / description is relevant for this issue: https://cgit.freedesktop.org/libreoffice/core/commit/?id=d464d505fbf6e53a38afdd3661d320fac8c760d6 and also 'non-linear interpretation of mousemoves' may step in? and all that's monstering around since 2014 ... with 21+ bugs and duplicates crying for help, i - assume - there might be one cardinal mistake being the source of all theese performance issues, e.g. wrong order when processing the comments or unnecessary recursions ... as @Julien wrote in c78: 'Sometimes, we notify n times because of a loop, instead of just notifying once (eg for redrawing) after the end of loop.' best performing versions (balanced between performance and click delays): 6.2.7.1 and 6.2.8.2, do me a favour and install and try theese versions (parallel install), if you can confirm my findings try to find someone who is able to save and port the better 'click reaction' of the 6.2 versions to the actual versions, besides: for theese issues windows versions (6.2) perform much better than linux, until solved i'd suggest: someone cares for theese things, they are important, or to implement a warning message: 'using too many comments / notes / post-it's / captions / annotations or tracking notes may slow down your system' to avoid ever recurring questions and irritated users. reg. b. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 --- Comment #95 from Timur --- *** Bug 131672 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324
--- Comment #94 from b. ---
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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 Timur changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||9228 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 --- Comment #93 from Noel Grandin --- I've done what I can, no longer looking at this bug -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 --- Comment #92 from b. --- pls. also look at: https://bugs.documentfoundation.org/show_bug.cgi?id=125619#c8 and #c9 regarding the data structure for comments used in the file. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 --- Comment #91 from David --- It seems that something that was changed for this bug which resulted in a regression for some files with a large number of comments that worked fine in version 6.2.7 but with version 6.3.* becomes basically unusable after an initial save. See bug 125619. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments ( see comment 85 )
https://bugs.documentfoundation.org/show_bug.cgi?id=76324 Xisco Faulí changed: What|Removed |Added Summary|CALC becomes very slow with |CALC becomes very slow with |5000+ comments |5000+ comments ( see ||comment 85 ) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
