Bug 85059 - Unable to open big MB files
Summary: Unable to open big MB files
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Presentation (show other bugs)
Version: Inherited From OOo
Hardware: All Windows (All)
: high critical
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: filter:ppt perf
Keywords:
Depends on: 85364
Blocks:
  Show dependency treegraph
 
Reported: 2014-10-15 13:19 UTC by SriJanani
Modified: 2014-11-28 09:42 UTC (History)
4 users (show)

See Also:
i915 platform:
i915 features:


Attachments
Attached MS file (2.18 MB, application/vnd.ms-powerpoint)
2014-10-15 13:19 UTC, SriJanani
Details
CPU details 1 (239.97 KB, image/jpeg)
2014-10-16 05:35 UTC, SriJanani
Details
CPU Details2 (184.89 KB, image/jpeg)
2014-10-16 05:35 UTC, SriJanani
Details

Description SriJanani 2014-10-15 13:19:18 UTC
Created attachment 107871 [details]
Attached MS file

Hi,


Facing difficulty in opening huge files no matter if its impres/calc/writer. The base files are created in Ms office(opens within a sec in MS office). Attaching the file. Appreciate your response.

Tested with all the versions of Libre office. Using windows platform.

Thank You,

Regards,
SriJanani
Comment 1 Jay Philips 2014-10-15 13:51:24 UTC
Hello SriJanani,

I was able to open it on 4.3.3 and master, though it took a bit of time to open, it did open after 2 or so minutes. How long does it normally take for you?
Comment 2 SriJanani 2014-10-15 15:28:34 UTC
It takes more than ten mins to load half through but never opens. We tried with version 4.3.2.2. Pls advice.


Regards 
Srijanani
Comment 3 tommy27 2014-10-15 18:10:46 UTC
@SriJanani
give exact details of your O/S and CPU
Comment 4 SriJanani 2014-10-16 05:35:06 UTC
Created attachment 107910 [details]
CPU details 1
Comment 5 SriJanani 2014-10-16 05:35:42 UTC
Created attachment 107911 [details]
CPU Details2
Comment 6 SriJanani 2014-10-16 05:36:11 UTC
Attached 2 screenshots of different PC.
Comment 7 SriJanani 2014-10-16 11:25:55 UTC
Can you tell me if you opening the same file in windows platform or anyother platform. After too many trys we tried the same file to open with openoffice it opened immediately. Any views on this.

Thank You,

Regards,
SriJanani
Comment 8 Jay Philips 2014-10-17 09:35:47 UTC
My previous test was on Linux Mint 13 32-bit.

I just tested 3.3.0, 3.6.7, 4.3.2 and master on Windows 7 64-bit and i cancelled trying to open the file after 5 minutes. The loading progress bar goes to around 60% and not any farther. Tried doing a backtrace but with no luck.
Comment 9 SriJanani 2014-10-17 09:48:18 UTC
Hi,

Right we have no clue why we are unable to open. We tried to open the same file in Open office 3.4.1 it opens without any issues.

Thank You,

Regards,
SriJanani
Comment 10 Jay Philips 2014-10-17 10:30:17 UTC
On Linux:
AOO 4.1: 3 seconds
LO  4.4: > 3 minutes with single core running at 100%

@Michael: Any ideas on how i can track down what is going wrong on Windows.
Comment 11 Jay Philips 2014-10-17 11:15:33 UTC
Waited 40 minutes to see if the file would open under Windows, but no luck.
Comment 12 SriJanani 2014-10-17 11:33:47 UTC
Even if you wait for an day it wont open..... Even other libre files cannot be opened.

Thank You,

Regards,
SriJanani
Comment 13 Michael Meeks 2014-10-17 18:44:32 UTC
Oh fun - just get a few stack traces during the load; it'll show the problem nicely I guess; odd though - I don't see any huge changes in our automated performance testing, so ... at least our test files are still loading nice & quickly there =) then again - we limit the size of those.

Seems to be spending a lot of time re-saving the embedded objects as ODF etc. and ... Hmm. not good.

Jay - I suspect that changing the defaults:

Tools->Options->Load/Save->Microsoft Office

around embedded objects [ we always convert them - otherwise they will not be editable ;-) - and I think AOO just leaves them as-is ].

This is a horrible false-dichotomy that shouldnt' exist; we should convert them as/when we need to on activation / macro use etc. but ... it is there.

Can you compare AOO with those options set.

Also - is this really a regression ? some big files that have not been optimised are slow - that's not really news =)
Comment 14 Matthew Francis 2014-10-18 05:51:07 UTC
Judging by the debug output, one problem is that we may be spending a long time failing to load referenced smb:// objects. The document appears to contain quite a few such references
Comment 15 Jay Philips 2014-10-18 09:20:40 UTC
(In reply to Michael Meeks from comment #13)
> Oh fun - just get a few stack traces during the load; it'll show the problem
> nicely I guess; odd though - I don't see any huge changes in our automated
> performance testing, so ... at least our test files are still loading nice &
> quickly there =) then again - we limit the size of those.

The problem here wasnt really the size of the file, so doubt it would effect any of the automated testing. ;D

> Seems to be spending a lot of time re-saving the embedded objects as ODF
> etc. and ... Hmm. not good.
> 
> Jay - I suspect that changing the defaults:
> 
> Tools->Options->Load/Save->Microsoft Office
> 
> around embedded objects [ we always convert them - otherwise they will not
> be editable ;-) - and I think AOO just leaves them as-is ].

Yes OpenOffice has these checkboxes unchecked and after unchecking them on LO, the file opened in 10 to 20 seconds on Windows. But what seems strange is that the file doesnt load on Windows with these checked, but loads on Linux with them checked.

> This is a horrible false-dichotomy that shouldnt' exist; we should convert
> them as/when we need to on activation / macro use etc. but ... it is there.
> 
> Can you compare AOO with those options set.

With checking these options in AOO, the file loads in > 4 minutes on Linux.

> Also - is this really a regression ? some big files that have not been
> optimised are slow - that's not really news =)

Well as this change was introduced in the first release of LO, then i wouldnt consider it a LO regression. :D
Comment 16 SriJanani 2014-10-23 05:52:13 UTC
I did tried to uncheck the embedded options and the files load quickly and accessible. So now how do we conclude the resolution. Please advice.

Thank You,

Regards,
SriJanani
Comment 17 Michael Meeks 2014-10-23 10:02:44 UTC
Well - it's an enhancement really; I hope there is another tracker enhancement for deferring the work here until embedded objects are activated; this whole idea of that setting is a global embarrassment ;-) we should "do it right".

It'd be nice to look for that enhancement to mark this one as being blocked by it  - if you can (?)
Comment 18 Jay Philips 2014-10-23 11:30:22 UTC
Filed it - bug 85364.
Comment 19 Björn Michaelsen 2014-11-28 09:42:18 UTC
(This is an automated message.)

LibreOffice development currently prioritizes bugs with the so called MAB (most annoying bugs) -- as this bug has not run through that process (including writing a short rationale for this bug being a candidate and other who are watching the tracker bug silently approving that rationale etc.) its priority is set to high. Note this is effectively no change in the urgency assigned to this bug, as we are currently not making a difference between high and highest and severity is untouched.

You can find out more about MABs and how the process works by contacting libreoffice qa on irc:

 http://webchat.freenode.net/?channels=libreoffice-qa

The QA wiki page also gives you hints on how to get in contact with the team (if IRC fails you, your next best choice is the mailing list):

 https://wiki.documentfoundation.org/QA


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.