Bug 121745 - Time to copy sheet has doubled
Summary: Time to copy sheet has doubled
Status: RESOLVED DUPLICATE of bug 133267
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.0.alpha0+
Hardware: All All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, perf, regression
Depends on:
Blocks:
 
Reported: 2018-11-27 18:23 UTC by Buovjaga
Modified: 2020-06-06 04:59 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Buovjaga 2018-11-27 18:23:20 UTC
1. Open attachment 142401 [details] from bug 117896
2. Right-click sheet KROSCEK - Move or copy sheet
3. Select "Copy" and "move to end position", OK

Time with the blamed commit is around 2min 38s.
Earlier commit: 1min 12s.

Bibisected with win32-6.2 to https://gerrit.libreoffice.org/plugins/gitiles/core/+/b9652803096b68a33702601aac52e78c8a4250c6%5E!/

tdf#118308: Incorrect Paste Special dialog when ...

pasting content from another cell

In tiled rendering case (headless) each window has its own clipboard,
otherwise exists a unique clipboard (UNO service).

Adding Cc: to Henry Castro
Comment 1 Xavier Van Wijmeersch 2018-11-28 08:22:47 UTC
following the description i have 4 cpu's running at 100% with low memory used (195MB) and need 470 seconds to complete the copy/moving
Opening and saving the document is between 5 and 10 seconds

Version: 6.3.0.0.alpha0+
Build ID: 75dd5d2e734ad9e8265b1954c7496d1ba241079e
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 2 Aron Budea 2018-12-03 07:07:49 UTC
For me with the blamed commit it's ~1:30, with the preceding one, ~0:42, and with latest commit from bibisect-win32-6.2 around ~1:10.
Comment 3 QA Administrators 2019-12-04 04:21:03 UTC Comment hidden (obsolete)
Comment 4 Buovjaga 2019-12-04 12:01:36 UTC
This is worse on Windows than Linux for some reason and perf has worsened over time. It took like 5 minutes now compared to my 2min 38s in 2018.

Version: 6.5.0.0.alpha0+ (x64)
Build ID: b9930d0d05db39a8466b18dccf626bc3d8ae5c4e
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: fi-FI (fi_FI); UI-Language: en-US
Calc: threaded
Comment 5 Telesto 2020-05-23 17:04:19 UTC
*** Bug 131709 has been marked as a duplicate of this bug. ***
Comment 6 Telesto 2020-05-23 17:04:48 UTC
*** Bug 133244 has been marked as a duplicate of this bug. ***
Comment 7 Telesto 2020-05-24 08:28:40 UTC
*** Bug 133316 has been marked as a duplicate of this bug. ***
Comment 8 Telesto 2020-05-31 15:48:53 UTC
Bumping a bit again.. the problem occurs in multiple situations..
Comment 9 Luboš Luňák 2020-06-05 11:23:01 UTC
I'm reasonably certain that my fix for bug#133267 improves also this case.

*** This bug has been marked as a duplicate of bug 133267 ***
Comment 10 Buovjaga 2020-06-05 11:37:06 UTC
(In reply to Luboš Luňák from comment #9)
> I'm reasonably certain that my fix for bug#133267 improves also this case.
> 
> *** This bug has been marked as a duplicate of bug 133267 ***

Indeed, the time has returned to the earlier 1min 12s in my Win virtual machine! Thanks.

Version: 7.1.0.0.alpha0+ (x64)
Build ID: 191288d6a7fb52b31038a21c4e71ee57ffa3bacd
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win
Locale: fi-FI (fi_FI); UI: en-US
Calc: threaded
Comment 11 b. 2020-06-05 15:31:41 UTC
issue left? 

exact steps from OP fast now, but: 

insert new sheet, goto sheet KROSCEK, ctrl-a - ctrl-c ... wait, more than 2:30 minutes on my machine, i see plenty lookup formulas, but none real critical or difficult, quite some cells, but 75k isn't too much, and copy shouldn't look them all up, just take value and formula from cell and copy ... ??? insert on new sheet is acceptabe fast, 

Version: 7.1.0.0.alpha0+ (x64)
Build ID: 75e1cf6c6ea83e65da248dab917b06feea6c18e4
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: CL
Comment 12 Buovjaga 2020-06-05 15:34:48 UTC
(In reply to b. from comment #11)
> issue left? 
> 
> exact steps from OP fast now, but: 
> 
> insert new sheet, goto sheet KROSCEK, ctrl-a - ctrl-c ... wait, more than
> 2:30 minutes on my machine, i see plenty lookup formulas, but none real
> critical or difficult, quite some cells, but 75k isn't too much, and copy
> shouldn't look them all up, just take value and formula from cell and copy
> ... ??? insert on new sheet is acceptabe fast, 

Can you report this as a new issue? If you can test with older versions, it would be helpful.