Bug 159198 - Improve loading time for simple, large spreadsheet document
Summary: Improve loading time for simple, large spreadsheet document
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.0.0 alpha0+ Master
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks:
 
Reported: 2024-01-15 13:59 UTC by Gabor Kelemen (allotropia)
Modified: 2024-01-30 01:02 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Calc (82.59 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-01-15 13:59 UTC, Gabor Kelemen (allotropia)
Details
Flamegraph made under Ubuntu 22, own build (352.86 KB, image/svg+xml)
2024-01-15 14:02 UTC, Gabor Kelemen (allotropia)
Details
Flamegraph of an empty document Calc opening, for reference (281.24 KB, image/svg+xml)
2024-01-15 14:04 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
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)