42742 – FILEOPEN: DOC: Documents with linked images take a long time to load

Bug 42742 - FILEOPEN: DOC: Documents with linked images take a long time to load

Summary: FILEOPEN: DOC: Documents with linked images take a long time to load

Status:	VERIFIED FIXED

Alias:	None

Product:	LibreOffice
Classification:	Unclassified
Component:	Writer (show other bugs)
Version: (earliest affected)	3.3.4 release
Hardware:	All All

Importance:	medium normal
Assignee:	Not Assigned

URL:
Whiteboard:	BSA
Keywords:	filter:doc, perf

Depends on:
Blocks:	DOC-Opening WebDAV
	Show dependency tree / graph

Reported:	2011-11-09 07:31 UTC by Yaytay
Modified:	2021-12-21 23:07 UTC (History)
CC List:	11 users (show)

See Also:	93341 99499
Crash report or crash signature:

Attachments
Sample document - Word doc created from web page (99.00 KB, application/msword) 2012-06-20 00:47 UTC, Yaytay	Details
Formatted dump of a packet trace generated whilst loading sample document. (1.76 MB, text/plain) 2012-06-20 00:54 UTC, Yaytay	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 Yaytay 2011-11-09 07:31:15 UTC

Problem description: 
I have an MS Word document containing ~15 linked images (the image source happens to be on wordpress.com).
Opening the document makes 230 HTTP round trips to wordpress.com and takes almost 4 minutes to complete.
The HTTP requests are all WebDAV requests.
This compares very badly with MS Word, which makes just 15 HTTP GET requests and completes in about 20s.

Steps to reproduce:
1. Create a Word doc document containing 15 linked images (it help demonstrate the problem if the server for the images is slow).
2. Load the document in LibreOffice.
3. Go have lunch.

Current behavior:
Lots of individual WebDAV requests making the opening of the document very slow.

Expected behavior:
One GET request per image and a nice quick load.
In a perfect world there would be two requests oustanding at any time and the doc would open in ~10s.

Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1

Comment 1 sasha.libreoffice 2012-04-19 04:54:55 UTC

Thanks for bugreport
Workaround: if we not need to real time update of pictures, then do Edit->Links and break all links.

> Opening the document makes 230 HTTP round trips to wordpress.com and takes
> almost 4 minutes to complete.
Currently it is very good that office not crashes and opens successfully.

Comment 2 Rainer Bielefeld Retired 2012-06-19 23:46:16 UTC

@Yaytay 
Please contribute a sample.doc!

Comment 3 Yaytay 2012-06-20 00:47:23 UTC

Created attachment 63245 [details]
Sample document - Word doc created from web page

A sample document.
On LibreOffice 3.5.2.2 this is taking 1 minute to load on my computer, which seems to be an improvement on what I was seeing before.
A packet trace shows that it is still downloading each image twice, but not bit-by-bit any more.

Comment 4 Yaytay 2012-06-20 00:54:27 UTC

Created attachment 63248 [details]
Formatted dump of a packet trace generated whilst loading sample document.

Attached a dump showing how many times each image is transferred, look for the dupes here:
S:\PacketTraces>find "Full request URI" LibreOfficeTrace.txt

---------- LIBREOFFICETRACE.TXT
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0001.jpg?w=424&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0001.jpg?w=424&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0001.jpg?w=424&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0001.jpg?w=424&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0014.jpg?w=429&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0014.jpg?w=429&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0014.jpg?w=429&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0014.jpg?w=429&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0020.jpg?w=134&h=64]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0020.jpg?w=134&h=64]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0020.jpg?w=134&h=64]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0020.jpg?w=134&h=64]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0083.jpg?w=405&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0083.jpg?w=405&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0083.jpg?w=405&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0083.jpg?w=405&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00931.jpg?w=238&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00931.jpg?w=238&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00931.jpg?w=238&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00931.jpg?w=238&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00921.jpg?w=237&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00921.jpg?w=237&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00921.jpg?w=237&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00921.jpg?w=237&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0101.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0101.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0101.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0101.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0100.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0100.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0100.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0100.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0112.jpg?w=379&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0112.jpg?w=379&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0112.jpg?w=379&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0112.jpg?w=379&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0110.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0110.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0110.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0110.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0095.jpg?w=400&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0095.jpg?w=400&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0095.jpg?w=400&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0095.jpg?w=400&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0118.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0118.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0118.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0118.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0124.jpg?w=458&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0124.jpg?w=458&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0124.jpg?w=458&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0124.jpg?w=458&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_2375.jpg?w=476&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_2375.jpg?w=476&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_2375.jpg?w=476&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_2375.jpg?w=476&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0001.jpg?w=424&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0001.jpg?w=424&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0001.jpg?w=424&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0001.jpg?w=424&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0014.jpg?w=429&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0014.jpg?w=429&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0014.jpg?w=429&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0014.jpg?w=429&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0020.jpg?w=134&h=64]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0020.jpg?w=134&h=64]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0020.jpg?w=134&h=64]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0020.jpg?w=134&h=64]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0083.jpg?w=405&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0083.jpg?w=405&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0083.jpg?w=405&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0083.jpg?w=405&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00931.jpg?w=238&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00931.jpg?w=238&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00931.jpg?w=238&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00931.jpg?w=238&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00921.jpg?w=237&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00921.jpg?w=237&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00921.jpg?w=237&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_00921.jpg?w=237&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0101.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0101.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0101.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0101.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0100.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0100.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0100.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0100.jpg?w=270&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0112.jpg?w=379&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0112.jpg?w=379&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0112.jpg?w=379&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0112.jpg?w=379&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0110.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0110.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0110.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0110.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0095.jpg?w=400&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0095.jpg?w=400&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0095.jpg?w=400&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0095.jpg?w=400&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0118.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0118.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0118.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0118.jpg?w=648&h=400]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0124.jpg?w=458&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0124.jpg?w=458&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0124.jpg?w=458&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_0124.jpg?w=458&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_2375.jpg?w=476&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_2375.jpg?w=476&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_2375.jpg?w=476&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_2375.jpg?w=476&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]
    [Full request URI: http://yaytay.files.wordpress.com/2009/11/img_01211.jpg?w=441&h=640]

S:\PacketTraces>

Comment 5 sasha.libreoffice 2012-06-20 03:35:40 UTC

Thanks for attachment
reproduced in 3.3.4 and 3.6 beta 1 (others not tested)
Importing of this document takes about 1 minute (CPU Pentium Core2 Duo 1.8Ghz, OS Fedora 64 bit)
Just after importing document it is without pictures. But after several minutes LO downloads pictures and all becomes correct.

Changing version to 3.3.4 as most early reproduced

Comment 6 Rainer Bielefeld Retired 2012-07-05 22:19:42 UTC

Hm, all this is a little cloak-and-dagger. 
It seems that reporter's sample indicates a bunch of possible problems, real bugs, possibilities to improve LibO, currently I believe we have to separate several problems, may be to submit several bugs.


Software           Document First      Furter      Remark
                   import   Picture    Pictures
-------------------------------------------------------------------------
LibO 3.5.5.3:      120s     10s        several s   [1] [2] [4]
LibO 3.3.3         150s     10s        several s   [1] [2] [4]
LibO 3.7.0.alpha+  120      10s        several s   [1] [2] [4] [5] [6] 
OOo 3.1.1          130s     20s        several s   [1] [2] [4]
OOo 1.1.4:          45s      1s         0s         [3]
MS Word Viewer:      3s      2s         2s         [1] [2]

Remarks:
[1] After Document has been opened only pictures in focus will be loaded. 
[2] When a new picture comes into focus it takes another 5s or Longer until picture will appear. One reason might be that some of the pictures on the server are created only for request, as I see from "w=424&h=640" in the picture URL. So the "document open" never becomes ready

[3] Document completely ready immediately, all pictures are aht their place and visible immediately when scrolling reaches it
[4] Import time of 120s for a 35 pages document seems to be rather long. After having saved the document as .odt reopening will only take a second or so, also with other versions than the one with what the document has been saved.
[5] Pictures nearby end of document seem to take much longer to become visible when in focus than pictures at the beginning _(but I did not test this systematically)
[6] PDF Export immediately after .doc has been opened takes several minutes (may be because pictures still have to be loaded one by one), also for .odt created from .doc. I only tested this for Master, but expect the same results for other Versions.

Remaining Questions:
a) is VBA code in the documents involved into the problems we see?

Possible Bugs / core Problems
A) General Import Time too long, OOo 1.1.4 is the minimum goal
B) Pictures should be loaded immediately and completely immediately when 
   document has been opened

I will have to think about these results, But I beleive we shoud separate this bug into 2 ones: 1. the picture download problem and 2. the too long import time until document becomes visible.

@Yaytay, @sasha
What do you think?

Comment 7 Yaytay 2012-07-06 01:04:16 UTC

There isn't any VBA in the document.

My feeling is that you will solve the "too long to import document" problem by resolving the issues with loading pictures.

A quick test with MS Word and Wireshark seems to indicate that it is 
1) Using some kind of cache (there are no network hits for the initial display with the first picture).
2) Other pictures are downloaded only when displayed.
3) Each picture download takes 0.3s - 0.6s.
4) Some pictures are downloaded using an "If-Modified-Since" header and get a 304 Not Modified response in ~0.1s.

So the thing that makes MS Word so quick seems to be that it inherently uses the IE cache, which may not be feasible for LO - but that only accounts for a factor of 5-10 difference (so the early OOo results).

It seems to me that LO is doing something with the images that is making it take a long time and download the image four times.

But this is all just analysis of the problem with inadequate information, the thing that I actually need to be quicker is the complete "open doc, save as PDF" cycle and any route you can take to achieve this is fine by me,

Comment 8 sasha.libreoffice 2012-07-06 07:15:08 UTC

I think that we should in msWord do Edit->Links and break all links. Then save document under new name. So we will separate slow opening problem from slow downloading problem.
(I can not help in this because have no Windows today)

Comment 9 Rainer Bielefeld Retired 2012-07-06 08:34:19 UTC

@sasha:
Yes, I already did, that heals the problem, what makes me rather sure that indeed the linked pictures are the problem.

Comment 10 Case Talbot 2013-09-16 23:20:53 UTC

I also experience this problem.  In my case the document took nearly 15 minutes to load because the images timed out.  But I was not the original author of that document, so this is a very bad user experience.  Image loading should be asynchronous and should not block loading the rest of the document.

Comment 11 QA Administrators 2015-04-01 14:40:41 UTC Comment hidden (obsolete)

** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

*Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.1 or later)
https://www.libreoffice.org/download/

*If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior

*If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

*Update the version field
*Reply via email (please reply directly on the bug tracker)
*Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)

If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:

1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword

Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2015-04-01

Comment 12 Buovjaga 2015-04-22 12:14:43 UTC

Yep, takes 1-2 mins.

Win 7 Pro 64-bit Version: 5.0.0.0.alpha0+ (x64)
Build ID: 211c12b9c64facd1c12f637a5229bd6a6feb032a
TinderBox: Win-x86_64@42, Branch:master, Time: 2015-04-18_01:51:17
Locale: fi_FI

Comment 13 Matthew Francis 2015-04-24 05:20:41 UTC

*** Bug 90700 has been marked as a duplicate of this bug. ***

Comment 14 Giuseppe Castagno (aka beppec56) 2015-11-23 08:49:22 UTC

Hi all,

I did some triage-debugging of the loading problem.

LO makes more than one check to load the single image because the ucp WebDAV layer, which is used in every net access involving http:// and https:// protocols, doesn't deal efficiently with standard web sites.

Using a debug version of an improvement I have in mind for the WebDAV layer, I was able to reduce the time needed to around 40 seconds, in LO 5.1 current master compiled in debug mode.

As soon as I can, I'll take care of the issue.

Comment 15 Michael Stahl (allotropia) 2015-11-26 11:48:32 UTC

Writer actually contains some infrastructure to load linked images in a separate thread, so that it does not block the UI:

SwGrfNode::TriggerAsyncRetrieveInputStream()
class SwAsyncRetrieveInputStreamThreadConsumer

this should be used if you import and ODT file, but it's possible that this is somehow not used when importing documents with legacy filters that operate directly on the sw core like the WW8 filter.

clearly linked images should be loaded in a non-blocking way because you have no idea what state the user's network is in.

also, Calc does not yet have anything equivalent (don't know about Impress), so there is probably some work to do in generalizing the sw implementation.

(another problem is that AFAIK the HTTP UCP does not currently implement any caching, so identical image URLs will be downloaded multiple times, which can easily happen if you copy-paste something from a browser)

Comment 16 Robinson Tryon (qubit) 2015-12-10 02:02:44 UTC Comment hidden (obsolete)

Migrating Whiteboard tags to Keywords: (perf)

Comment 17 Giuseppe Castagno (aka beppec56) 2016-08-11 18:00:29 UTC

Tested with daily master on Windows 10 64bit:

Version: 5.3.0.0.alpha0+ (x64)
Build ID: 8b9d5798f157d18652adcc94bdf89f00b2a3b20c
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; 
TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2016-08-11_10:39:12
Locale: it-IT (it_IT); Calc: CL

Took around 40 sec to load the images the first time (up to the macro security alert message).
Closed the document, reopened, it took less: around 10 sec.

I added code to cache the type of server the URL resource lives on, that is after the first access, for a limited amount of time, the access is similar to what a browser would do.

A URL resource data cache is not yet implemented.

Comment 18 QA Administrators 2018-01-10 03:31:51 UTC Comment hidden (obsolete)

** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)

If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword

Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

Comment 19 Rainer Bielefeld Retired 2018-01-10 05:42:30 UTC Comment hidden (no-value)

Thank you for reminding me to leave CC list.

Comment 20 Roman Kuznetsov 2018-09-10 21:05:34 UTC

in 

Версия: 6.1.1.1 (x64)
ID сборки: 2718b4a18dfcc6a54ebe5f7b801ee7a47fa81e0c
Потоков ЦП: 4; ОС:Windows 10.0; Отрисовка ИП: GL; 
Локаль: ru-RU (ru_RU); Calc: CL

Opening of file takes 20 sec

Comment 21 Xisco Faulí 2019-04-02 14:33:38 UTC

it takes

real	0m50,395s
user	0m5,043s
sys	0m0,629s

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

Comment 22 Xisco Faulí 2019-04-02 14:37:36 UTC

Similar timing in

Version: 5.2.0.0.alpha1+
Build ID: 5b168b3fa568e48e795234dc5fa454bf24c9805e
CPU Threads: 4; OS Version: Linux 4.15; UI Render: default; 
Locale: ca-ES (ca_ES.UTF-8)

Comment 23 QA Administrators 2021-04-02 03:47:18 UTC Comment hidden (obsolete)

Dear Yaytay,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword

Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

Comment 24 Roman Kuznetsov 2021-09-21 14:21:23 UTC

(In reply to Roman Kuznetsov from comment #20)
> in 
> 
> Версия: 6.1.1.1 (x64)
> ID сборки: 2718b4a18dfcc6a54ebe5f7b801ee7a47fa81e0c
> Потоков ЦП: 4; ОС:Windows 10.0; Отрисовка ИП: GL; 
> Локаль: ru-RU (ru_RU); Calc: CL
> 
> Opening of file takes 20 sec

Opening took 41 sec in

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 80a47aae1419842f4496f02028e2b49763aea25b
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded

it became some worse

Comment 25 Gabor Kelemen (allotropia) 2021-11-22 22:49:59 UTC

With new webdav-curl backend opening takes about 12 seconds on my laptop, while on the same machine in 7.3-bibisect master still takes about 35 seconds.

Comment 26 Buovjaga 2021-11-24 06:55:09 UTC

Let's close as fixed as we know the work that fixed it.

Comment 27 Thorsten Behrens (allotropia) 2021-12-21 23:07:37 UTC

Verified improved perf.