[Libreoffice-bugs] [Bug 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

  Regression By||Armin Le Grand

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Telesto  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] [Bug 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Telesto  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=12
   ||3542

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Telesto  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=13
   ||1675

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

--- Comment #27 from Telesto  ---
*** Bug 125641 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

--- Comment #26 from b.  ---
I'm actually not using Calc but came across an issue which remained me on the
comments / notes problem.  
_Assume_ it could be something like 'loop in loop', 'nested loops', which work
well when developed / tested / used with small datasets, but expose evil
'superlinear behaviour' reg. 'quadratic-' or 'exponential-explosion' with 'big
data' above some threshold.  
Such may harm execution time ( recursions ) or mem-usage ( large tables ) or
both.  
If someone knowing Calc's code finds such in it...  
- either avoiding nested loops,  
- if unavoidable work with binary search in sorted lists,  
- and or the proposals in  
https://answers.sap.com/questions/2497299/how-to-avoid-loop-inside-the-loop-.html
, 
https://answers.sap.com/questions/546841/how-to-avoid-the-loop-inside-loop-.html
,  
https://stackoverflow.com/questions/18014889/how-to-avoid-quadratic-computation-resulting-from-double-for-loop-when-computi
,  
could evtl. help?

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Gabor Kelemen (allotropia)  changed:

   What|Removed |Added

 CC||kelem...@ubuntu.com

--- Comment #25 from Gabor Kelemen (allotropia)  ---
I can reproduce the issue with the first attachment 154800 (about 10k cells
filled with text+comment).
Upon opening the file my system monitor reports about 280Mb memory use for
soffice.bin, then saving the file as another name makes this go to about 900Mb,
and even closing the file does not free this memory.

Randomly pointing to cells and waiting for their comment box to show up also
shows quite a bit of waves in CPU use.

Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: 9c796266470183f673eb58a8637dfe621eefa8b3
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: hu-HU (hu_HU.UTF-8); UI: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 CC||ilmari.lauhakangas@libreoff
   ||ice.org

--- Comment #24 from Buovjaga  ---
b.: could you run new tests with a fresh master build as it was discovered that
Calc comment handling performance has improved recently?

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

--- Comment #23 from b.  ---
Created attachment 165389
  --> https://bugs.documentfoundation.org/attachment.cgi?id=165389&action=edit
evil effect of (auto)save

for those who do not believe in the 'bad influence' of autosave here is a
visualization:  

i used the sheet / macro from the above comment to create 150.000 cells with
comments (A2: 15 - A3: 1 - start macro), and observed the resource usage and
commented attached screenshot: 

1. - close calc (7.1.0.0.a0+), 
2. - open calc (7.1.0.0.a0+), 
3. - open the sheet with the macro, 
4. - start generation of the cells, 
5. - slow progress in the production, 
6. - start of autosave (after 9 minutes), 
7. - inadvertent opening of calc 7.0 parallel, 
8. - calc 7.0 closed, 7.1 continues to run, 
9. - memory full, 
10. - finished and display of the result, 

the used memory will be released only after closing calc, i.e. until then the
computer works with 'memory full', 

that certainly does not! help the system to work smooth and performant, 

(same happens if the cell creation is finished before autosave) 

the effect of many comments is already unhealthy, 

autosave - or any other save - in addition is catastrophic ... :-(

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

b.  changed:

   What|Removed |Added

 CC||newbie...@gmx.de

--- Comment #22 from b.  ---
Created attachment 165379
  --> https://bugs.documentfoundation.org/attachment.cgi?id=165379&action=edit
file with macro to test 'comment performance' in LO calc,

it gets better gradually, but the processing of comments in calc is still a
huge problem,  

i have attached a sheet with a small macro, it should be self-explanatory,
fresh loaded you likely have to activate the form control toolbar via [view -
toolbars - form controls] and deactivate 'edit mode' there, otherwise the macro
button won't work, 

with '1' and '0' in A2 and A3 you can time the generation of 10.000 cells
without comments, and with '1' and '1' the time for the same with comments, 

with higher numbers in A2 more cells are created and it takes longer, 

i find that 1 second for 150.000 and 4 seconds for 2.000.000 cells without
comments, compared to 411 seconds for 150.000 cells with comments, shows that
the handling of comments in calc is still 'not very effective' ... 

the problem gets much worse after the first (auto-)save, the memory usage is
more than doubled after that, maybe this is an indication, 

similar delays occur in the handling of 'normal' files with many comments, to
one of the many threads about it someone had attached a Lenovo article list
with 25.000 comments, useless for everyday work :-(

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

--- Comment #21 from David  ---
Something has definitely changed with version 7.10 alpha.  Version 7.02 still
has the problem, but in 7.10 alpha, using the sample file, changing cells after
a save is now approximately twice as fast as in 7.02.  But changing cells in my
real life file is now immediate.  There is no observable delay in that file in
ver. 7.10 alpha, while it is still a major issue in 7.02.

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=76
   ||324

--- Comment #20 from Xisco Faulí  ---
Maybe this is one of those bugs that seems like a regression to the end user
but in the end it's just an old issue which is more visible now.
According to comment 17, that might be the case here, and this issue might be a
duplicate of bug 76324

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

--- Comment #19 from Miklos Vajna  ---
Done, it's now on the ESC agenda, see
.
However, just to set expectations: the ideal outcome of bisected regression is
that the author of the problematic commit deals with it. It's rare that it
happens otherwise.

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

 CC||vmik...@collabora.com

--- Comment #18 from Julien Nabet  ---
(In reply to Noel Grandin from comment #17)
> This is the same problem I mentioned in that other bug, that requires a
> fairly major refactoring of how comments/notes work in calc.

Miklos: could it be a subject discussed on ESC?

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

--- Comment #17 from Noel Grandin  ---
This is the same problem I mentioned in that other bug, that requires a fairly
major refactoring of how comments/notes work in calc.

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 Attachment #155628|0   |1
is obsolete||

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 CC||noelgran...@gmail.com

--- Comment #16 from Xisco Faulí  ---
Still reproducible in

Version: 7.0.0.0.alpha1+
Build ID: 1ffe59ef31186e36ad0aa7bbcdd32e407ee8d26c
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Steps to reproduce:
1. Open attachment 154800
2. Save it with another name

-> it hangs

@Noel, I thought you might be interested in this issue since Julien attached a
flamegraph

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 Attachment #155622|0   |1
is obsolete||

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Telesto  changed:

   What|Removed |Added

   Priority|medium  |high

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Telesto  changed:

   What|Removed |Added

 Blocks||101216


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=101216
[Bug 101216] [META] Calc comment bugs and enhancements
-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Telesto  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=12
   ||8402

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Telesto  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=12
   ||5641

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

--- Comment #15 from Julien Nabet  ---
Created attachment 156867
  --> https://bugs.documentfoundation.org/attachment.cgi?id=156867&action=edit
Flamegraph (with gen rendering)

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

--- Comment #14 from Julien Nabet  ---
Created attachment 156866
  --> https://bugs.documentfoundation.org/attachment.cgi?id=156866&action=edit
Flamegraph

Here's a Flamegraph retrieved on pc Debian x86-64 with master sources updated
today (gtk3 rendering).

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Telesto  changed:

   What|Removed |Added

 Blocks||128256


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=128256
[Bug 128256] [META] Regressions introduced by Refactor calc non-linear
ViewToDevice transform
-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Telesto  changed:

   What|Removed |Added

   Keywords||perf

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Telesto  changed:

   What|Removed |Added

 CC||serval2...@yahoo.fr

--- Comment #13 from Telesto  ---
@Julien
A flamegraph would be nice ;-)

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Telesto  changed:

   What|Removed |Added

 CC||armin.le.gr...@me.com
   Keywords|bibisectRequest |bibisected, bisected

--- Comment #12 from Telesto  ---
Addding CC: to Armin Le Grand

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

--- Comment #11 from Telesto  ---
Bibisected to
author  Armin Le Grand   2018-10-12 11:13:09 +0200
committer   Armin Le Grand   2018-11-27 11:33:10
+0100
commit  d464d505fbf6e53a38afdd3661d320fac8c760d6 (patch)
tree3bf7db8591172bf948198f19d36df5df886486bb
parent  3e1e2b6687b0259ae28441cc0d314de0d908776b (diff)
Refactor calc non-linear ViewToDevice transform

https://cgit.freedesktop.org/libreoffice/core/commit/?id=d464d505fbf6e53a38afdd3661d320fac8c760d6

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

--- Comment #10 from b.  ---
apologize: 

- there is! some more structure in the stored files, 

- cells are noted row by row from left to right, 

- all rows are filled till max-cols-used, 

- empty cells are padded with 'cols-repeated' or similar, 

- jump to next row is marked with 

but it's still a sequential list with sequential access, or did i miss more
structure? 


observations: 

- *.ods files are a flavour of zip archives which can be opened with - e.g. -
7zip, 

- David's attachment is 'usable' with ver. 6.4.0.0 alpha1+, 

this version still shows 'enhanced cpu-load on mousemoves', and 'delayed
reaction on mouseclicks', but reduced to former versions, 

just 6.2.7.1 had been better, by a factor of about 2, 

Davids file has about 10k comments, 

somewhere above 40k i touch a limit where no version is usable, 

contrary filling 4M cells with numbers or formulas is - nothing - and takes -
nearly - not time, 

*
the funny thing that the negative impact of above performance problems is at
least doubled after any? save of the file or even just a 'save a copy' is
persistent, 
*

all above said for win version. 

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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

--- Comment #9 from b.  ---
Created attachment 155628
  --> https://bugs.documentfoundation.org/attachment.cgi?id=155628&action=edit
file 'content.xml' from att. 154800 opened in firefox

... continued: 

the files manifest.xml and others opened in text-editor (gedit?) and showed
some info too cryptical for me, the file content.xml shot gedit into digital
nirvana with endless massive cpu-load and fan noise. So I thought this file was
broken, but I managed to open it with firefox. 

It consists of a header with several style definitions, and then the block I
marked blue in the screenshot repeats the same thing several thousand times,
with two variables 'svg:x' (from 80.99 to 6672,98 in steps of 64: 104 entries)
and 'svg:y' (from 0 to 1267.2 in steps of about 12.8: 100 entries). 

(I assume that represents 104 columns from A to AZ and 100 rows from 1 to 100,
with only graphical coordinates where to place something.)

I have massive difficulties imagining any program that could work effectively
with this data structure. 

The data is a !list! that can only be accessed by searching? And whose values
can only be assigned to a cell with float calculations of graphical
coordinates? 

if you do this for the full list on every dot of a move of the mouse ... you
get massive unproductive overhead. 

One might do things like this if to handle a manageable amount of values ...
but as the number of comments in calc is limited only by the number of cells in
the sheet?, this structure causes a behavior that when programming and testing
with few comments everything slides wonderfully, with larger amounts of
comments massive problems have to occur. 

(high-res screens may contribute to the impact by increasing the number of
moves that must be evaluated.)

In my opinion, one would have to rework the data structure in such a way that:
- each entry for a comment is marked as to which cell it belongs
- these 'cell coordinates' can be used as an index to access the comments,
(a two-dimensional array ([0 to max-used-col; 0 to max-used-row]: string;
attributes)?

But that's a job for programmers, my contribution as a user is to show that the
data structure used is something between ridiculous and terrible.

Please correct me and I apologize very much, of course, if I misunderstood
something.

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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

--- Comment #8 from b.  ---
Created attachment 155622
  --> https://bugs.documentfoundation.org/attachment.cgi?id=155622&action=edit
many-comments.ods (att. 154800) from David shown as folder? after download

hello @all, 
hello and thanks @David and @Telesto for help in digging down, 

no solution, but may be some help ... 

i always wanted to know how a '.ods' file works internally, when downloading
David's attachment 154800 some of it was revealed. Strangely enough it wasn't
opened with calc, but displayed as a kind of 'folder', see attached screenshot.
More in the next comment. 

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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Telesto  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
   Keywords||bibisectRequest, regression
 Ever confirmed|0   |1

--- Comment #7 from Telesto  ---
Repro with
Version: 6.4.0.0.alpha0+ (x86)
Build ID: c45d477b0a0038d9c25176cf7cff299e5ddf3a7a
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-09-30_05:06:55
Locale: nl-NL (nl_NL); UI-Language: en-US
Calc: CL

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   Assignee|genericinet+libreoffice.org |libreoffice-b...@lists.free
   |@gmail.com  |desktop.org

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

David  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |genericinet+libreoffice.org
   |desktop.org |@gmail.com
 Status|NEEDINFO|NEW

--- Comment #6 from David  ---
Created attachment 154800
  --> https://bugs.documentfoundation.org/attachment.cgi?id=154800&action=edit
Spreadsheet with many comments

Following the instructions in the first post provides a file that is unusable
in 6.3, for all practical purposes, after an initial save.  Functions correctly
in 6.2.7.  See attachment.

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #5 from Xisco Faulí  ---
(In reply to David from comment #4)
> I have not tried yet the test given in the first post, but I also have a
> large spreadsheet that began to exhibit this behaviour with version 6.3. 
> Version 6.2.7 works fine.  When I load the spreadsheet in version 6.3, the
> behaviour is normal until the spreadsheet gets saved, then it gets extremely
> slow when doing any input.  Removing all the comments corrects the problem.

Please attach a sample document, as this makes it easier for us to verify the
bug. 
(Please note that the attachment will be public, remove any sensitive
information before attaching it. 
See
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
for help on how to do so.)

I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' once the requested document is provided.

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

David  changed:

   What|Removed |Added

 Ever confirmed|0   |1
 Status|UNCONFIRMED |NEW

--- Comment #4 from David  ---
I have not tried yet the test given in the first post, but I also have a large
spreadsheet that began to exhibit this behaviour with version 6.3.  Version
6.2.7 works fine.  When I load the spreadsheet in version 6.3, the behaviour is
normal until the spreadsheet gets saved, then it gets extremely slow when doing
any input.  Removing all the comments corrects the problem.

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

QA Administrators  changed:

   What|Removed |Added

 Whiteboard| QA:needsComment|

-- 
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 125619] 'performance problem with plenty comments' still in 6.3 alpha1, *only after save of file/autosave*

[bugzilla-daemon]

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

b.  changed:

   What|Removed |Added

Summary|'performance problem with   |'performance problem with
   |plenty comments' still in   |plenty comments' still in
   |6.3 alpha1, *only after |6.3 alpha1, *only after
   |autosave?*  |save of file/autosave*

-- 
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