Bug 104781 - FILEOPEN DOCX: Time to open file has increased compared to LibO4463
Summary: FILEOPEN DOCX: Time to open file has increased compared to LibO4463
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
5.0.6.3 release
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:docx, notBibisectable, perf, regression
Depends on:
Blocks: DOCX-Opening
  Show dependency treegraph
 
Reported: 2016-12-19 13:37 UTC by Telesto
Modified: 2019-10-31 17:06 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2016-12-19 13:37:03 UTC
Description:
FILEOPEN ODT: Slow file opening compared to LibO 4.4.6.3. (but hard to pin down because of the SAXParseException issue (bug 99227)

Steps to Reproduce:
1. Open attachment 124282 [details] (bug 99227)

Actual Results:  
File opening takes around 14 seconds 

Expected Results:
LibO 4.4.6.3 opens the file in around 5 seconds


Reproducible: Always

User Profile Reset: No

Additional Info:
Found in
Version: 5.4.0.0.alpha0+
Build ID: 53edf60c4ce6ed32f87471e018878c40b788005a
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2016-12-18_06:57:59
Locale: nl-NL (nl_NL); Calc: CL

but not in:
Versie: 4.4.6.3 
Build ID: e8938fd3328e95dcf59dd64e7facd2c7d67c704d
Locale: nl_NL


User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0
Comment 1 Buovjaga 2016-12-19 16:44:10 UTC
Yep, a bit slower.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha0+
Build ID: db9aec4520766c87a09d4cb0238ed06ebaeaaeeb
CPU Threads: 8; OS Version: Linux 4.8; UI Render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on December 18th 2016
Comment 2 Timur 2016-12-20 16:38:38 UTC
To repeat https://bugs.documentfoundation.org/show_bug.cgi?id=99227#c17 : 
attachment 129777 [details] contains debug from procdump dump, if of any use
Comment 3 Terrence Enger 2016-12-30 23:55:09 UTC
Working on debian-stretch I observe in the bibisect-50max repository
that LibreOffice opened the file in about 11 seconds up to the error
message introduced in s-h ebf767ee.  The latest version in that
repository also displays the error message.

Within the daily linux dbgutil bibisect repository, my oldest version
(2016-05-26) takes about 1 minute 29 seconds to open the file.

I conclude that the slowness came into LibreOffice sometime between
2015-01-22 and 2016-05-26.  I am leaving keyword bibisectRequest in
the hope that somebody can be more helpful than I have been.
Comment 4 Aron Budea 2017-01-19 03:58:13 UTC
Already slow in 5.0.6.3 and 5.1.0.3 / Windows 7. Giver errors on import in 5.0.0.5. I'll go with notBibisectable.
Comment 5 QA Administrators 2018-01-20 03:33:35 UTC Comment hidden (obsolete)
Comment 6 Roman Kuznetsov 2018-12-24 20:55:01 UTC
I got 16 sec in

Версия: 6.2.0.1 (x64)
ID сборки: 0412ee99e862f384c1106d0841a950c4cfaa9df1
Потоков ЦП: 4; ОС:Windows 10.0; Отрисовка ИП: GL; VCL: win; 
Локаль: ru-RU (ru_RU); UI-Language: ru-RU
Calc: threaded

still repro

but are you sure that in LO 4.4 this file opens full correct?
Comment 7 Xisco Faulí 2019-04-02 14:12:25 UTC
it takes 

real	0m9,624s
user	0m9,270s
sys	0m0,278s

in

Version: 6.3.0.0.alpha0+
Build ID: 3b518953a8141b0d5043c2f3996a92956fdc3a47
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

which seems reasonable in an 7 years old computer. I think we can close this as a RESOLVED WORKSFORME
Comment 8 Telesto 2019-04-02 14:24:27 UTC
(In reply to Xisco Faulí from comment #7)
> it takes 
> 
> real	0m9,624s
> user	0m9,270s
> sys	0m0,278s
> 
> in
> 
Probably depending on the backend. It's certainly slower on Windows 
Version: 6.3.0.0.alpha0+
Build ID: 8d45d5ee399d0148672e79c379f5d29e1c8ba6f3
CPU threads: 4; OS: Windows 6.3; UI render: GL; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-03-29_01:02:58
Locale: nl-NL (nl_NL); UI-Language: en-US
Calc: CL

@but are you sure that in LO 4.4 this file opens full correct?
-> No clue, didn't check
Comment 9 Xisco Faulí 2019-04-02 14:26:36 UTC
(In reply to Telesto from comment #8)
> (In reply to Xisco Faulí from comment #7)
> > it takes 
> > 
> > real	0m9,624s
> > user	0m9,270s
> > sys	0m0,278s
> > 
> > in
> > 
> Probably depending on the backend. It's certainly slower on Windows 
> Version: 6.3.0.0.alpha0+
> Build ID: 8d45d5ee399d0148672e79c379f5d29e1c8ba6f3
> CPU threads: 4; OS: Windows 6.3; UI render: GL; VCL: win; 
> TinderBox: Win-x86@42, Branch:master, Time: 2019-03-29_01:02:58
> Locale: nl-NL (nl_NL); UI-Language: en-US
> Calc: CL
> 
> @but are you sure that in LO 4.4 this file opens full correct?
> -> No clue, didn't check

Please, be accurate when talking about timing. certainly slower doesn't help...
Comment 10 Telesto 2019-04-02 15:06:15 UTC
> Please, be accurate when talking about timing. certainly slower doesn't
> help...

16 seconds. same as comment 6
Comment 11 Xisco Faulí 2019-04-02 15:19:14 UTC
12 seconds in

Versión: 6.2.2.2
Id. de compilación: 2b840030fec2aae0fd2658d8d4f9548af4e3518d
Subprocs. CPU: 1; SO: Windows 6.1; Repres. IU: predet.; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES
Calc: threaded

in the same computer running Win 7 in a VM.

@Telesto, please measure the timing in 4.4.6.3 with the same computer and add the attach the pdf export from 4.4.6.3 and master so see if anything changed...
Comment 12 QA Administrators 2019-09-30 02:52:13 UTC Comment hidden (obsolete)
Comment 13 QA Administrators 2019-10-31 03:37:10 UTC Comment hidden (obsolete)
Comment 14 Terrence Enger 2019-10-31 17:06:19 UTC
Working with bibisect-linux-64-6.4 repository s-h c4d760b9
(2019-10-28) on debian-buster, I observe the following cumulative CPU
time to (*) reach approximately 0 CPU usage after opening the file,
(*) position to end of document (*), close the document.

                   VCL:x11  VCL:x11  VCL:gtk3
                   -------  -------  --------
    open file       7.13     6.95     9.53
    <ctrl>+<End>    7.79     7.53     9.69
    <ctrl>+W        8.06     7.89    10.17

I shall leave it to Telesto to change bug status, if he wishes.