Bug 133996 - Very slow opening of a ODS with autofilter + conditional formatting
Summary: Very slow opening of a ODS with autofilter + conditional formatting
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, perf, regression
Depends on:
Blocks: File-Opening
  Show dependency treegraph
 
Reported: 2020-06-15 08:28 UTC by Telesto
Modified: 2020-08-03 20:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
flamegraph (1.94 MB, image/svg+xml)
2020-06-26 13:16 UTC, Xisco Faulí
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2020-06-15 08:28:52 UTC
Description:
Very slow opening of a ODS with autofilter + conditional formatting

Steps to Reproduce:
1. Open attachment 155912 [details] -> takes 35 minutes to open (bug 121386)


Actual Results:
35 minutes opening time

Expected Results:
5 minutes like 4.1 (in 4.1 it's iterating row count in 7.1 ScMatrix)


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: a201ab6f47c2d5a7ba4c5f998b0aa231cae82010
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

not in
4.4.7.2 based on the very sleepy feedback (look "same" as in 7.1)

but not in
4.1
Comment 1 Xisco Faulí 2020-06-15 13:48:38 UTC
it takes

real	6m50,396s
user	7m9,147s
sys	0m6,759s

in

Version: 7.1.0.0.alpha0+
Build ID: 37d5cccceb9f02d60de326f5b1fc5098dc004739
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Don't think it's a regression
Comment 2 Telesto 2020-06-15 14:35:48 UTC Comment hidden (no-value)
Comment 3 Telesto 2020-06-15 20:39:08 UTC
First my lesson: Never trust numbers given by bug reporter..

Anyhow: 
with 7.1 (win): 5:20 
with 4.4.7.2 (win): waited 9 minutes.. kill
with 4.2 (win): 3:30 

Now the quest: reducing the file to something which can be bibisected.. or the boring task of bibisected this using the file at hand.
Comment 4 Xisco Faulí 2020-06-26 13:16:07 UTC
Created attachment 162424 [details]
flamegraph

While recording the flamegraph, I killed LibreOffice after a while, since the document never finished to load
Comment 5 Xisco Faulí 2020-06-26 13:20:51 UTC
(In reply to Xisco Faulí from comment #4)
> Created attachment 162424 [details]
> flamegraph
> 
> While recording the flamegraph, I killed LibreOffice after a while, since
> the document never finished to load

@Noel, I thought you might be interested in this performance issue