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 tree / graph
 
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
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 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