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: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
3.3.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: filter:doc, perf
Depends on:
Blocks: DOC-Opening
  Show dependency treegraph
 
Reported: 2011-11-09 07:31 UTC by Yaytay
Modified: 2021-09-21 14:21 UTC (History)
9 users (show)

See Also:
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

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)
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)
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)
Comment 19 Rainer Bielefeld Retired 2018-01-10 05:42:30 UTC Comment hidden (no-value)
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)
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