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: [email protected]
Reporter: [email protected]
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.
