Bug 124194 - Loading files in Calc 5 times slower in 6.2.1.2 snap than in v6.2.0.1 .deb
Summary: Loading files in Calc 5 times slower in 6.2.1.2 snap than in v6.2.0.1 .deb
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.1.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: File-Opening
  Show dependency tree / graph
 
Reported: 2019-03-19 04:23 UTC by Dan Dascalescu
Modified: 2019-08-15 03:17 UTC (History)
2 users (show)

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 Dan Dascalescu 2019-03-19 04:23:16 UTC 
Sample file: https://bugs.documentfoundation.org/attachment.cgi?id=133113

Version: 6.2.1.2
Build ID: libreoffice-6.2.1.2-snap1
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Time from clicking "Open" to seeing the "Macros" warning dialog: 17 seconds

Version: 6.2.0.1
Build ID: 0412ee99e862f384c1106d0841a950c4cfaa9df1
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Time from clicking "Open" to seeing the "Macros" warning dialog: 3.5 seconds

Is this a SNAP issue, or a regression?

Config: Thinkpad X1 Carbon laptop with SSD and 16GB RAM, Core i5 CPU. Files were loaded "warm", i.e. measured the load time for the second load.

Does LibreCalc have tests for respecting a "performance budget"[1], for example ensuring that a given file loads on a given or better configuration in at most X seconds?

[1]: the "performance budget" concept for web apps - https://addyosmani.com/blog/performance-budgets/
Comment 1 m_a_riosv 2019-03-19 13:44:45 UTC 
No delay here with
Version: 6.2.2.2 (x64)
Build ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US
Calc: threaded

Maybe some option gives the issue, please test with a clean profile Menu/Help/Restart in Safe mode
Comment 2 Dan Dascalescu 2019-04-25 19:05:20 UTC 
I can not see the delay in 6.2.3.2 DEB. Maybe it was a problem with the SNAP package specifically?
Comment 3 Buovjaga 2019-08-14 16:25:16 UTC 
You could report it here in case it persists in 6.3: https://bugs.launchpad.net/ubuntu/+source/libreoffice
Comment 4 Dan Dascalescu 2019-08-14 22:12:25 UTC 
I understand that slow loading *of LibreCalc* from the snap should be reported to  the Ubuntu packagers, but the issue I ran into was slow loading of files AFTER Calc had been started.
Comment 5 Buovjaga 2019-08-15 03:17:36 UTC 
(In reply to Dan Dascalescu from comment #4)
> I understand that slow loading *of LibreCalc* from the snap should be
> reported to  the Ubuntu packagers, but the issue I ran into was slow loading
> of files AFTER Calc had been started.

If Canonical devs determine the problem to be in upstream, we can always revisit this report.