Bug 159198

Summary:	Improve loading time for simple, large spreadsheet document
Product:	LibreOffice	Reporter:	Gabor Kelemen (allotropia) <kelemeng>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	stephane.guillou
Priority:	medium	Keywords:	perf
Version:	24.8.0.0 alpha0+
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=159194
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Example file from Calc Flamegraph made under Ubuntu 22, own build Flamegraph of an empty document Calc opening, for reference

Description Gabor Kelemen (allotropia) 2024-01-15 13:59:21 UTC

Created attachment 191951 [details]
Example file from Calc

Attached example file contains about 12 sheets of simple text.
Opening this file takes a short time, but even that is more than the same content saved as xlsx is opened in Excel.
This report is to explore options to reduce load times as much as possible in this simple content case.

1. Open attached file in current nightly from the commandline, using 
time OOO_EXIT_POST_STARTUP=1 program/soffice large-textcontent-cleared.ods

with hot cache this gives:
real    0m6,908s
user    0m0,000s
sys     0m0,000s

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 25276df12abd9d002f7f899900434617b256f745
CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: de-DE (hu_HU); UI: de-DE
Calc: threaded

(based on the amount of CLI output, this seems to be a dbgutil build, but still)

Comment 1 Gabor Kelemen (allotropia) 2024-01-15 14:02:24 UTC

Created attachment 191952 [details]
Flamegraph made under Ubuntu 22, own build

Comment 2 Gabor Kelemen (allotropia) 2024-01-15 14:04:08 UTC

Created attachment 191953 [details]
Flamegraph of an empty document Calc opening, for reference

Comment 3 Stéphane Guillou (stragu) 2024-01-30 01:01:48 UTC

I am able to start editing in about 4 seconds with:

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 2cedb1a19ad605df4e148589e9027512e4dd9265
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

But if you see potential for improvements, of course let's do it :)

Comment 4 Stéphane Guillou (stragu) 2024-01-30 01:02:39 UTC

(sorry, ODS here)