Apache OpenOffice (AOO) Bugzilla – Issue 128121
calc produces unneccessary? cpu load in files with plenty comments
Last modified: 2019-06-04 21:10:00 UTC
i have an performance issue with calc from libreoffice, it gets slowdowns, hangs and crashes once files have extensive comments ('measureable' up from 100, 'feelable' up from 200, 'affecting speed in work' up from 400, crashes up from 4000), depending on system etc. as the bug is quite old and somewhere commented as 'inherited from OO', but not yet resolved, i came over here to check how AOO performs. It's working better, i could produce a sheet with 32k comments, but ... could not save it, some of it's content is injected into a new created sheet, graphics is fucked up, even the new sheet couldn't be saved also after deleting all content, ... thus a sheet with plenty comments is a problem for AOO too. one significant thing i can see 'problem' or not is the cpu load produced by just hovering around with the mouse. it's '0' to '1' on an empty sheet, the same on a sheet with data, and increases too ~8 % on my system when the sheet has many comments in it. one can easily check with the taskmanager of windows. (libreoffice used up to 14%). i assume there is something 'suboptimal' in the implementation of comments, may be an ineffictive data structure, one-way references causing searches instead of indexed access, unneccessary recursions, unsorted lists or whatever, just something easy for program, OS and hardware while handling a few comments, but with linear or exponential increase of ressource use acc. to the number of comments. it would be very nice if someone can crosscheck my tests, and if commited ask someone with skills, knowledge and time to check whether the situation can be stabilized. for reference: my system: Lenovo thinkpad P70, xeon, 16 gb ecc ram, m1 ssd disk, win7pro SP1 (x64), AOO 4.1.6, AOO416m1(Build:9790) - Rev. 1844436 2018-10-23 12:57. i do not provide a problem file ... couldn#t save one, it's quite easy to produce, key '1' in A1, add the comment '1', copy that cell with ctrl-c, and paste it to e.g. A1:D8000 with ctrl-v. reg. b.
Already reported *** This issue has been marked as a duplicate of issue 109276 ***
@oooforum (fr): sorry, sorry, sorry, me bad, pls. beliiieeeve me i did! do a search before posting, didn't find that ... ??? typo? ??? see below list of issues and retests today, still an issue, happy: i'm not alone, sad: something affecting the fun to work with OO and LO in a massive negative way is 'still in' after *10* years, ecological: just an assumption: 8 billion people worldwide, 4 billions awake, 1 billion using computers, 10 % (100 millions) using spreadsheets, 20 % (20 millions) LO or OO (maybe the bug is in e$x$cel as well), 50 % using comments (10 millions), theese wasting 20 watt of cpu-power for comments ... the impact is 200 Megawatt!, about one sixth of a usual big nuclear power plant :-(, with german average prices 60.000 EUR per hour? (since ten years?) ... besides massive wasting time of users ... what i *dislike* abut that bug (deepl'ed): it creeps in unnoticed, gradually increases with the amount of data until users notice a problem, but then there's no clue what the cause is, they're wasting time on research, or slow work, or switch to another program. And even before using comments, there was no hint: 'Beware!, too many comments can drastically slow down your system!'. searched again today and found three the same issues: Issue 109276 - Calc is extremely slow when spreadsheet has many notes (comments) reported *2010*-02-15 09:20 UTC by cianoz status today: Status: UNCONFIRMED tested today: hard work for system to copy content, errors like 'no space to copy here', lightning fast after stripping comments, thus: still issue, Issue 117348 - freeze or out of memory , when paste a lot of cells with comment. reported *2011*-03-12 04:12 UTC by paz_ohhashi status today: Status: UNCONFIRMED tested today: Issue 117348: high load and delay and 'not responding' on copying the row with comments, had to kill the task, thus: still issue, Issue 127715 - Changes in spreadsheet with many notes (comments) extremely slow reported 2018-02-26 12:26 UTC by orion status today: Status: UNCONFIRMED tested today: visible delays alredy with very small amounts of data and comments, thus: still issue, and even more domino-like after noticing that comments are called 'notes' as well: Issue 102716 - Calc is very slow for some operations (with many notes) reported *2009*-06-12 13:20 UTC by sukender this is at least Status: CONFIRMED tested today: deleting a line, heavy load and 'not responding', thus: still issue, Issue 111390 - OOo Calc 3.0.1 and higher --> Notes bug reported: *2010*-05-05 09:12 UTC by jsteenks despite being confirmed in: https://bz.apache.org/ooo/show_bug.cgi?id=111390#c2 status today: Status: CLOSED *IRREPRODUCIBLE* but some useful info in: https://bz.apache.org/ooo/show_bug.cgi?id=111390#c4 tested today: small sheet, few comments, first no problem, maybe i didn't get the functionality of the sheet, unfolded invisible rows and cols, added 75k cells with '1' in it commented '1', dead, sorry, fnished and came back to live after ~10 minutes, 13 % of cpu-load on hovering with the mouse over the sheet, thus: still issue, Issue 111037 - An example of XLS/ODS file which slows down OOo reported: *2010*-04-21 11:10 UTC by hiddenman this is at least Status: CONFIRMED tested today: visible delays, graphics fu**ed after deleting one column, 15 times faster after strippung comments, thus: still issue, i'd stop listing here, my impression, there is a 'big bug', and one will find plenty other complaints about performance which did not get the boildown to the root 'comments' or 'notes', but which do rely on theese effects and you'll see it once you test 'em against this issue. so please again beliiieeeve me, there is an issue, this bug is! a duplicate of more than one others, as they are still unresolved it's an appeal to take this issue seriously ... reg. b.
This was closed as a duplicate for a reason as there is already a previous report all comments should be added to that open report to keep all pertinent information in a single place. I will mark issue 109276 as reconfirmed in AOO 4.1.6. *** This issue has been marked as a duplicate of issue 109276 ***