Bug 103439 - FILEOPEN takes a long time on a small file with pictures in it
Summary: FILEOPEN takes a long time on a small file with pictures in it
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks:
 
Reported: 2016-10-23 19:46 UTC by Christian
Modified: 2018-12-10 16:01 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
example file with 50x100 cells (170.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-10-23 19:46 UTC, Christian
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Christian 2016-10-23 19:46:08 UTC
Created attachment 128196 [details]
example file with 50x100 cells

I'm using Libreoffice 5.0.6.2 Build-ID 1:5.0.6-0ubuntu1 on Ubuntu Linux 15.10.

I have a file with 50x100 cells and every cell has a small picture in it. Opening this file takes about 9 minutes and top tells me that the process only uses one of my 8 processors (or cores). My computer has a intel core i7 3770k which is a little bit overclocked to run at 4.2 ghz.

In my opinion this behaviour is completely unacceptable, espacially that libreoffice only uses one core which leads me to the conclusion that there is no real multithreading implemented. But i haven't investigated this that much to say anything more profound about it.
Comment 1 Julien Nabet 2016-10-24 07:30:05 UTC
5.0 branch is EOL.
Please give a try to last stable LO version 5.2.2 (I think you may find it on LO ppa).
Comment 2 Cor Nouws 2016-10-24 07:43:46 UTC
(In reply to Christian from comment #0)
> Created attachment 128196 [details]
> example file with 50x100 cells
> 
> I'm using Libreoffice 5.0.6.2 Build-ID 1:5.0.6-0ubuntu1 on Ubuntu Linux
> 15.10.

I confirm this on daily20161020.
Thanks for filing - interesting document and test!

> In my opinion this behaviour is completely unacceptable, espacially that
> libreoffice only uses one core which leads me to the conclusion that there
> is no real multithreading implemented. But i haven't investigated this that
> much to say anything more profound about it.

Yes, do that first :)
Comment 3 Cor Nouws 2016-10-24 07:45:12 UTC
@christian: how did you make that file, or any idea of the origin of it?
Anyway: same problem in 3.3.0
Comment 4 Christian 2016-10-25 19:51:29 UTC
@Cor Nouws: maybe I have some spare time to try debugging a little bit deeper but normally thats not my daily business.
I created the file by myself simply by copy&pasting it in all the cells I needed. The creation was also really slow but at the time of creation it wasn't something special for me. I was astonished as I had to open the file again half an hour later and it took me longer then the creation.

@Julien Nabet: I will update my computer to the newest Ubuntu release tonight but as Cor Nouws already confirmed it seems to be a really old bug.
Comment 5 Cor Nouws 2016-10-25 21:33:24 UTC
@Christian

(In reply to Christian from comment #4)

> I created the file by myself simply by copy&pasting it in all the cells I
> needed. The creation was also really slow but at the time of creation it

OK, thanks. It's just to know that it's not from some 'strange' application that created it.

> @Julien Nabet: I will update my computer to the newest Ubuntu release
> tonight but as Cor Nouws already confirmed it seems to be a really old bug.

And still present in recent dailys.

The bug is new and marked as perf, so up to the devs (or maybe you?) to see where in the code the time is spent..

Ciao
Comment 6 Christian 2016-10-27 20:41:09 UTC
Just watched some minutes of multithread cpu usage via ps, here just 10 seconds, it looks the same the whole time till the file is completely loaded:
  PID   TID PSR %CPU
 5033  5033   6 99.6
 5033  5035   1  0.0
 5033  5037   5  0.0
 5033  5038   1  0.0
 5033  5039   7  0.0
 5033  5040   7  0.0
 5033  5041   7  0.0
  PID   TID PSR %CPU
 5033  5033   6 99.6
 5033  5035   1  0.0
 5033  5037   5  0.0
 5033  5038   1  0.0
 5033  5039   7  0.0
 5033  5040   7  0.0
 5033  5041   7  0.0
  PID   TID PSR %CPU
 5033  5033   6 99.6
 5033  5035   1  0.0
 5033  5037   5  0.0
 5033  5038   1  0.0
 5033  5039   7  0.0
 5033  5040   7  0.0
 5033  5041   7  0.0
  PID   TID PSR %CPU
 5033  5033   6 99.6
 5033  5035   1  0.0
 5033  5037   5  0.0
 5033  5038   1  0.0
 5033  5039   7  0.0
 5033  5040   7  0.0
 5033  5041   7  0.0
  PID   TID PSR %CPU
 5033  5033   6 99.6
 5033  5035   1  0.0
 5033  5037   5  0.0
 5033  5038   1  0.0
 5033  5039   7  0.0
 5033  5040   7  0.0
 5033  5041   7  0.0
  PID   TID PSR %CPU
 5033  5033   6 99.6
 5033  5035   1  0.0
 5033  5037   5  0.0
 5033  5038   1  0.0
 5033  5039   7  0.0
 5033  5040   7  0.0
 5033  5041   7  0.0
  PID   TID PSR %CPU
 5033  5033   6 99.6
 5033  5035   1  0.0
 5033  5037   5  0.0
 5033  5038   1  0.0
 5033  5039   7  0.0
 5033  5040   7  0.0
 5033  5041   7  0.0
  PID   TID PSR %CPU
 5033  5033   6 99.7
 5033  5035   1  0.0
 5033  5037   5  0.0
 5033  5038   1  0.0
 5033  5039   7  0.0
 5033  5040   7  0.0
 5033  5041   7  0.0
  PID   TID PSR %CPU
 5033  5033   6 99.7
 5033  5035   1  0.0
 5033  5037   5  0.0
 5033  5038   1  0.0
 5033  5039   7  0.0
 5033  5040   7  0.0
 5033  5041   7  0.0
  PID   TID PSR %CPU
 5033  5033   6 99.7
 5033  5035   1  0.0
 5033  5037   5  0.0
 5033  5038   1  0.0
 5033  5039   7  0.0
 5033  5040   7  0.0
 5033  5041   7  0.0
Comment 7 QA Administrators 2017-10-28 17:47:23 UTC Comment hidden (obsolete)
Comment 8 Christian 2017-10-31 16:00:21 UTC
Bug is still present in LibreOffice 5.4.2 from the website
Comment 9 QA Administrators 2018-12-07 03:47:25 UTC Comment hidden (obsolete)
Comment 10 Christian 2018-12-07 15:14:38 UTC
Bug got fixed, tested Version is 6.1.3-1
Comment 11 Xisco Faulí 2018-12-10 16:01:52 UTC
Thanks for retesting with the latest version.
Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been identified.