Bug 158774

Summary:	Serious slowdown in recent Libreoffice calc release
Product:	LibreOffice	Reporter:	Andy <silvandy>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	miguelangelrv, telesto, vsfoote
Priority:	medium	Keywords:	bibisectRequest, perf, regression
Version:	7.6.4.1 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Some large simulation of a bootstrap statistical procedure

Description Andy 2023-12-19 12:11:54 UTC

Description:
On a Calc file containing some large number of random formulas, recalculation of formulas and general navigation is MUCh slower on LO 7.6.4 than on LO 3.3

Steps to Reproduce:
1.Open the attached file in LO 7.6.4
2.Apply a recomputing (for example with ctrl+shift+F9). On my HP i7 machine, the recomputing takes 14.80 seconds approximately
3.Now Open the same file in LO 3.3
4. the same operation takes about half the time: 7 seconds approximately
5. also, scrolling of the spreadsheet is normally fast in 3.3, while if you navigate the cells in 7.6.4 things move way way slower, it is almost unusable

Actual Results:
LO 7.6.4 turns out to be much slower than LO 3.3 on the same file

Expected Results:
Running times should be at least the same, if not better


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.6.4.1 (X86_64) / LibreOffice Community
Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1
CPU threads: 8; OS: Windows 10.0 Build 17763; UI render: default; VCL: win
Locale: it-IT (it_IT); UI: it-IT
Calc: threaded

Old version: LO 3.3.4

Comment 1 Andy 2023-12-19 12:13:59 UTC

Created attachment 191502 [details]
Some large simulation of a bootstrap statistical procedure

This file is just an example, the same performance regression takes place with  other similar files as well

Comment 2 V Stuart Foote 2023-12-19 13:31:50 UTC

(In reply to Andy from comment #0)
> 
> Expected Results:
> Running times should be at least the same, if not better
> 

Why, the Calc framework now holds table space an 2 orders of magnitude larger than the OOo era sheets.

Comment 3 Telesto 2023-12-19 16:28:58 UTC

I measured file opening times
55 seconds with Master
28 seconds with 7.1 alpha
28 seconds with 4.4.7.2

Modifying cell C3 to 2 
14 seconds with Master
10 seconds with 7.1 alpha

Comment 4 ady 2023-12-19 18:15:18 UTC

The lag is most probably related to 16k columns, effective by default since LO 7.4. Comparing the times between 7.3.x and 7.4 would probably (almost) confirm it.

Comment 5 m_a_riosv 2023-12-20 01:58:17 UTC

Opening 21 seconds with
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: bcbc0857bf4bc24b5ea36e445a367cce0a382da4
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded

Comment 6 Telesto 2023-12-20 02:29:50 UTC

(In reply to Andy from comment #0)
> if you navigate the cells in 7.6.4 things move way way slower, it is almost     > unusable

UI render: default; VCL: win

This is should be Skia/Raster. Tools -> Options -> View. Cjeck Force Skia Software Rendering and restart

Comment 7 Andy 2023-12-20 09:56:50 UTC

Yes you're right, navigation is fast as in 3.3 with Skia on. Thanks a lot