[Libreoffice-bugs] [Bug 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #18 from Telesto  ---
(In reply to Buovjaga from comment #17)
> Um, I don't get any slowness from pasting attachment 134059 [details] 
> Please test with a recent build.
> 
I didn't check, but indeed. It's pretty decent:
Version: 6.1.0.0.alpha0+
Build ID: ef22c4a0a99be5d2903fb9e9d09fc852cd791173
CPU threads: 4; OS: Windows 6.3; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-01-12_09:16:04
Locale: nl-NL (nl_NL); Calc: CL

However, it's still slow with OpenGL enabled

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #17 from Buovjaga  ---
Um, I don't get any slowness from pasting attachment 134059 
Please test with a recent build.

Arch Linux 64-bit
Version: 6.1.0.0.alpha0+
Build ID: ef22c4a0a99be5d2903fb9e9d09fc852cd791173
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded
Built on January 12th 2018

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #16 from Buovjaga  ---
(In reply to Telesto from comment #15)
> Second attempt: might be related to bug 108608

That is Draw and this is Calc. Should do a callgrind on this, though...

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #15 from Telesto  ---
(In reply to Buovjaga from comment #14)
> (In reply to Telesto from comment #13)
> > Maybe a dupe of bug 84099 ?
> 
> Nope, bug 84099 already appears with 4.2.0.

Second attempt: might be related to bug 108608

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #14 from Buovjaga  ---
(In reply to Telesto from comment #13)
> Maybe a dupe of bug 84099 ?

Nope, bug 84099 already appears with 4.2.0.

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #13 from Telesto  ---
Maybe a dupe of bug 84099 ?

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

   Keywords||bibisectRequest, perf,
   ||regression
 Status|UNCONFIRMED |NEW
 CC||todven...@suomi24.fi
 Ever confirmed|0   |1
   Severity|normal  |major

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #12 from Francewhoa 
 ---
Test results:
• File in comment #8 is 129 lines, 773 characters with spaces, 0.7 kB size.
  Results in ~2 seconds lag per action. Calc IS usable :)

• File in comment #9 is 235 lines, 1,409 characters with spaces, 1.4 kB size. 
  Results in ~11 seconds lag per action. Calc is NOT usable :(

• File in comment #10 is 470 lines, 2,819 characters with spaces, 2.8 kB size. 
  Results in ~100 seconds lag per action. Calc is NOT usable :(

• File in comment #11 is 940 lines, 5,639 characters with spaces, 5.6 kB size. 
  Results in ~780 seconds lag per action. Calc is NOT usable :(

The lag is both correlated with the number of lines and exponential with the
number of lines. In other words, the lag per action ranges from ~2 seconds with
129 lines to more than 13+ minutes lag with 940+ lines, and so on and
exponential.

Notice that the results above are sorted top down in lag time results. The last
result in comment #11 is ~780 seconds lag which means ~13 minutes lag. That is
longg for just one action with simple text without calculation and minimum
formatting. So long I could feel my beard growing and I needed a second shave
after the lag, LOL (joke ;) Also during that long lag period all LibreOffice
tools are frozen and not usable. So the users can not use Calc, Write, or any
other LibreOffice tool. In my personal experience, after 5 to 10 seconds lag
most users feel the software crashed, froze, or is not working, most user don't
know it is a lag.

All those tests are using LibreOffice 5.2.7.2. Steps to reproduce and details
in this ticket description above.

While testing, another thing I noticed is during the lag one CPU is used at
100%. If the computer as multiple CPUs, for example 8 CPUs, then each CPU is
used in turn at 100%. Roughly 2 to 3 seconds each at 100%. So one CPU always at
100%. That means users with fast CPU at 3+ GHz and 8+ CPU might not notice the
~2 seconds lag with the file in comment #8 at 129 lines. But users with slower
or less CPU(s) might face the challenge of having both their LibreOffice and
their full computer not usable during a longer lag.

If you try to reproduce this lag, I suggest to double check that you do at
least two actions on a large cell, not just one action. Because sometime when
using a freshly open and blank Calc spreadsheet, the first action is very fast
with a large cell. The lag is sometime triggered only with the second action
with a large cell, and all following actions. By "action" I mean action on a
large cell such as open, edit, or paste into.

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #11 from Francewhoa 
 ---
Created attachment 134091
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134091=edit
lorem_ipsum---940_lines---5639_characters---Francewhoa---2017-06-17.txt

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #10 from Francewhoa 
 ---
Created attachment 134090
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134090=edit
lorem_ipsum---470_lines---2819_characters---Francewhoa---2017-06-17.txt

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #9 from Francewhoa 
 ---
Created attachment 134089
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134089=edit
lorem_ipsum---235_lines---1409_characters---Francewhoa---2017-06-17.txt

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #8 from Francewhoa 
 ---
Created attachment 134088
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134088=edit
lorem_ipsum---129_lines---773_characters---Francewhoa---2017-06-17.txt

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #7 from Francewhoa 
 ---
I'll post shortly 4 new files which I used to further narrow down the source(s)
of the issue

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #6 from Francewhoa 
 ---
The main difference between the files attached in comment #5 and #2 above are
their length. 129 lines compare to 235 lines. So somehow the lag is triggered
when the cell content is between line 130 and 235.

Here is a summary of the test results with LibreOffice (LO) using file in #2
for the cell content

• With LO 4.2 Francewhoa was NOT able to reproduce
• With LO 5.0.0.5 Telesto was NOT able to reproduce
• With LO 5.0.6.3 Telesto was ABLE to reproduce
• With LO 5.2.7.2 Francewhoa was ABLE to reproduce
• With LO 6.0.0.0.alpha0+ Telesto was ABLE to reproduce

So it seems something was introduce between 5.0.0.5 and 5.0.6.3

#5 result in a small lag. Just ~2 seconds per operation. So Calc is still
usable if the cell is below 129 lines. But conditional to the user having a
fast CPU. Intel Core i7 at 3.10 GHz with 8 CPUs. 

#2 result in a much bigger lag. ~30 seconds per operation. So Calc is not
usable. Notice that roughly double the number of cell lines result in 15 times
more lag. So the lag is both directly correlated to the number of lines in the
cell, and the lag is also exponential. Ho Ho :O. In other words, the lag
increase rapidly with additional lines in the cell.

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #5 from Francewhoa 
 ---
Created attachment 134084
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134084=edit
Dependencies.txt

Shorter text file for testing. With 130 lines. Thanks to smagoun :)

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

Telesto  changed:

   What|Removed |Added

 CC||tele...@surfxs.nl
Version|5.2.7.2 release |5.0.6.3 release
 OS|Linux (All) |All

--- Comment #4 from Telesto  ---
I do notice quite some lag with:
Version: 6.0.0.0.alpha0+
Build ID: cbf371e07fd5dea1ea08a1f299360d1273961ebd
CPU threads: 4; OS: Windows 6.19; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-06-14_23:13:57
Locale: nl-NL (nl_NL); Calc: CL

and with
Version: 5.0.6.3
Build ID: 490fc03b25318460cfc54456516ea2519c11d1aa-GL
Locale: en-US (nl_NL)

but not with
Version: 5.0.0.5
Build ID: 1b1a90865e348b492231e1c451437d7a15bb262b
Locale: nl-NL (nl_NL)

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #3 from Francewhoa 
 ---
Created attachment 134060
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134060=edit
screenshot---About_LibreOffice---Francewhoa---2017-06-15.jpg

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #2 from Francewhoa 
 ---
Created attachment 134059
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134059=edit
lorem_ipsum---Francewhoa---2017-06-15.txt

Text used to reproduce this challenge

-- 
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 108560] EDITING: Slow Edit or Open Large Cells

[bugzilla-daemon]

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

--- Comment #1 from Francewhoa 
 ---
Created attachment 134058
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134058=edit
calc_spreadsheet---before---Slow_Edit_Large_Cell---Francewhoa---2017-06-15.ods

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