You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2019/06/02 23:52:08 UTC
[Issue 128121] New: calc produces unneccessary? cpu load in files
with plenty comments
https://bz.apache.org/ooo/show_bug.cgi?id=128121
Issue ID: 128121
Issue Type: DEFECT
Summary: calc produces unneccessary? cpu load in files with
plenty comments
Product: Calc
Version: 3.3.0 or older (OOo)
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: ui
Assignee: issues@openoffice.apache.org
Reporter: newbie-02@gmx.de
Target Milestone: ---
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.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128121] calc produces unneccessary? cpu load in files with
plenty comments
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128121
Keith N. McKenna <kn...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |DUPLICATE
CC| |knmc@apache.org
Status|UNCONFIRMED |RESOLVED
--- Comment #3 from Keith N. McKenna <kn...@apache.org> ---
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 ***
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128121] calc produces unneccessary? cpu load in files with
plenty comments
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128121
b. <ne...@gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|DUPLICATE |---
Status|CLOSED |UNCONFIRMED
--- Comment #2 from b. <ne...@gmx.de> ---
@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.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128121] calc produces unneccessary? cpu load in files with
plenty comments
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128121
oooforum (fr) <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128121] calc produces unneccessary? cpu load in files with
plenty comments
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128121
oooforum (fr) <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |DUPLICATE
CC| |oooforum@free.fr
--- Comment #1 from oooforum (fr) <oo...@free.fr> ---
Already reported
*** This issue has been marked as a duplicate of issue 109276 ***
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128121] calc produces unneccessary? cpu load in files with
plenty comments
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128121
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.