Bug 162523 - A file with lots of tables, bookmarks and footnotes is slow to load
Summary: A file with lots of tables, bookmarks and footnotes is slow to load
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
24.2.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: haveBacktrace, perf
Depends on:
Blocks: Performance
  Show dependency treegraph
 
Reported: 2024-08-19 17:18 UTC by Daniele
Modified: 2024-11-02 19:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Test file (2.13 MB, application/vnd.oasis.opendocument.text)
2024-08-19 17:18 UTC, Daniele
Details
Perf flamegraph of file opening (4.19 MB, image/svg+xml)
2024-10-29 20:41 UTC, Buovjaga
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Daniele 2024-08-19 17:18:17 UTC
Description:
When editing big files such as those we use (2,4MB) with tables, bookmarks and thousands of footnotes, the loading time can go up to 1 minute or more and saving time is very long 2-7 seconds (sometimes it takes longer).
If the user wants to use automatic saving s/he should then negotiate between a short saving time and a usability issue. If I use 1minute I cannot type continuously any more because I have to wait every minute for the saving process to finish.

Steps to Reproduce:
1.Open file attached
2.Change saving settings to 1 minute (or) hit the save button

Actual Results:
Long saving times

Expected Results:
Should save in the background allowing users to keep working.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59
CPU threads: 8; OS: macOS 14.5; UI render: Skia/Metal; VCL: osx
Locale: en-US (en.UTF-8); UI: en-US
Calc: threaded
Comment 1 Daniele 2024-08-19 17:18:58 UTC
Created attachment 195905 [details]
Test file
Comment 2 Buovjaga 2024-10-29 20:40:17 UTC
Saving in background is bug 48416.

I do confirm the slow loading and particularly the long wait until a responsive UI. A bit tricky as a report as we are not sure which of the document elements are causing this.

Looking at a flamegraph, a lot of work is spent in bookmarks and tables indeed.
Comment 3 Buovjaga 2024-10-29 20:41:09 UTC
Created attachment 197295 [details]
Perf flamegraph of file opening

With OOO_EXIT_POST_STARTUP=1

Arch Linux 64-bit
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7b91fc00a01e973937861a212750b12ffaaf9501
CPU threads: 8; OS: Linux 6.10; UI render: default; VCL: kf6 (cairo+wayland)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: CL threaded
Built on 29 October 2024