Bug 161846 - Saving a ODS with plenty of comments very slow; massive amount of CPU time spend in SfxItemPool::GetItemSurrogates
Summary: Saving a ODS with plenty of comments very slow; massive amount of CPU time sp...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-06-30 10:25 UTC by Telesto
Modified: 2024-06-30 12:52 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2024-06-30 10:25:05 UTC 
Description:
Saving a ODS with plenty of comments very slow; massive amount of CPU time spend in SfxItemPool::GetItemSurrogates(std::__1::vector<SfxPoolItem const*, std::__1::allocator<SfxPoolItem const*>>&, unsigned short) const

Steps to Reproduce:
1. Open attachment 144526 [details] (bug 119075)
2. Press save... no progress bar  or anything, but using single core 	                                    


Actual Results:
Very slow . There where already perf issues: bug 119075 bug 125619 bug 131675. However it becomes incrementally worse in different area's


Expected Results:
A more snappy experience


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9c1a48f844eaefc505a5914338b6f444011bf315
CPU threads: 8; OS: macOS 14.3; UI render: Skia/Raster; VCL: osx
Locale: nl-NL (nl_NL.UTF-8); UI: en-US
Calc: threaded
Comment 1 Telesto 2024-06-30 10:28:20 UTC 
Possible of relevance https://gerrit.libreoffice.org/c/core/+/162254
Comment 3 Telesto 2024-06-30 12:47:39 UTC 
Same on Windows
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c39e4f6b8a942680bc7250177c34fd034a0605e0
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
Comment 4 Telesto 2024-06-30 12:52:04 UTC 
Saving slow, but faster with 
Version: 7.6.3.0.0+ (X86_64) / LibreOffice Community
Build ID: 35f19e5cb93ce218787904e99c2bedfd40e725cc
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL threaded

File open performance is also faster with
Version: 7.6.3.0.0+