Bug 150623

Summary: Switching between filled and empty sheets slow (sc::RowHeightContext)
Product: LibreOffice Reporter: Telesto <telesto>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: buzea.bogdan, hossein
Priority: medium Keywords: bibisectRequest, perf
Version: 7.4.0.3 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 136524    

Description Telesto 2022-08-26 12:01:16 UTC
Description:
Switching between sheets slow (sc::RowHeightContext)

Steps to Reproduce:
1. Open attachment 157561 [details]
2. Right click the sheet -> Add Sheet -> Add sheet to the right
3. Switch back & forward between tabs

Actual Results:
8 - 12 seconds lag

Expected Results:
Maybe 2 /3 seconds lag,


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 1c1647e6ee252fe68d7406d01043e88f1721590f
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: nl-NL
Calc: CL
Comment 1 Telesto 2022-08-26 12:03:22 UTC
Performance is better with
Version: 7.1.8.0.0+ (x64) / LibreOffice Community
Build ID: a94b58277c7aeaa83ce14347cd0b8f7137969d03
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL
Comment 2 BogdanB 2022-08-26 13:34:08 UTC
Confirm with
Version: 7.4.0.2 (x64) / LibreOffice Community
Build ID: 1512ce97d7ed39dce3121f7e15651fd8895f950e
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: ro-RO (ro_RO); UI: en-US
Calc: threaded

Also in
Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 5ac75131556b687a01517ce4520a05bb49c1d840
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: ro-RO (ro_RO); UI: en-US
Calc: threaded
Comment 3 BogdanB 2023-09-23 13:23:29 UTC
I changed the earliest version according to comment 2.
Comment 4 BogdanB 2023-09-24 17:28:41 UTC
It's very hard to bibisect this. I am getting from 5,6-10,11 seconds, nothing relevant with 7.4. Couldn't be here used an automated bibisect with time and ./instdir/program/soffice and to use good or bad depending on seconds?

There are a lot of bugs to bibisect which have performance problems, and it's hard to detect the differences. I had 5 seconds, than 10 seconds. But maybe just happened.