Bug 144435 - Lots of time spend saving
Summary: Lots of time spend saving
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks:
 
Reported: 2021-09-10 20:06 UTC by Telesto
Modified: 2022-03-01 11:32 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Example file (14.47 MB, application/vnd.oasis.opendocument.spreadsheet)
2021-09-10 20:06 UTC, Telesto 		Details
View All 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 2021-09-10 20:06:05 UTC 
Description:
Lots of time spend saving

Steps to Reproduce:
1. Open the attached file
2. press Save.. 15 seconds


Actual Results:
15 seconds

Expected Results:
Well, the problem is me being without reference. OK, CVS export works in 3 seconds.. 


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 96d1240adf946c443fb2c369a1c84e31e259c7a8
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: nl-NL
Calc: CL
Comment 1 Telesto 2021-09-10 20:06:49 UTC 
Created attachment 174959 [details]
Example file
Comment 2 Telesto 2021-09-10 20:25:55 UTC 
@Noel,
This needs an assessment of someone with optimization expertise. 

The default argument would be it's large file (14,15 MB) with lots of rows.. so a lot of XML to process compared to CVS. So the saving speed being as expected and normal.

The stack doesn't reveal any serious madness. But well speed hasn't changed since years; where fast parser intended to be faster (or is import only) and CVS export being insanely fast

So more double checking this being the highest speed achievable
Comment 3 m_a_riosv 2021-09-11 11:08:41 UTC 
About 8-10 seconds
Version: 7.2.1.2 (x64) / LibreOffice Community
Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
About 13 seconds
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 4cd3ce9848aa039b8d443a1257d1298231680b01
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
Comment 4 Luboš Luňák 2022-03-01 11:32:28 UTC 
The uncompressed XML output is ~250MiB. Current master is as good as it gets.