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
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
(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.
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
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.
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
(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
Yes you're right, navigation is fast as in 3.3 with Skia on. Thanks a lot
Still repro, although with different results compared to comment 3 (across the board) Opening time: 30 seconds without UI feedback (LibO appears to be frozen) Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 055c906d7b3f2e3709292d1410358d4e66a500ed CPU threads: 4; OS: Windows 8.1 X86_64 (6.3 build 9600); UI render: Skia/Raster; VCL: win Locale: nl-NL (nl_NL); UI: en-US Calc: CL threaded Opens within 10 seconds with 4.4.7.2
The issue is with RANDBETWEEN(1;400) calculation in the attached sample, there are 200000 of them, change it to RANDBETWEEN(1;20) and it works without slowness.
In version 7.0 RANDBETWEEN has become volatile. Try to replace it with the non-volatile RANDBETWEEN.NV.