Issue 123858 - Needs too much time to open document with CHART
Summary: Needs too much time to open document with CHART
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.1.0-dev
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: performance
Depends on:
Blocks:
 
Reported: 2013-12-16 05:36 UTC by Rainer Bielefeld
Modified: 2014-03-18 16:28 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
Statistics showing bad AOO performance (20.05 KB, application/vnd.sun.xml.calc)
2013-12-22 15:50 UTC, Rainer Bielefeld 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Rainer Bielefeld 2013-12-16 05:36:05 UTC 
Steps how to reproduce Reproducible with server installation of "AOO 4.1.0-Dev – English  UI / English locale - [AOO410m1(Build:9750)  -  Rev. 1546757 - 2013-12-02]" on German WIN7 Home Premium (64bit)", own separate user profile:

1. From AOO Start center open attached sample document:
   Expected: needs 10s or so
   Actual: 160s

Additional info:
----------------
Performance became worse since AOO 2.0:
OOo 2.0.2 OOo 3.1.1  OOo 3.3.0  AOO 3.4.0  AOO 4.0.1  AOO 4.1.0-dev  LibO 4.1.0.3
9 s       17 s       16 s       41 s       98 s       160 s          53 s

I will submit some additional bugs with performance issues for this document.
Comment 1 Edwin Sharp 2013-12-16 08:54:26 UTC 
Attachment?
Comment 2 Rainer Bielefeld 2013-12-16 09:30:22 UTC 
Argh, sorry, file too large for attachment.
Please download sample document from
<http://www.bielefeldundbuss.de/OOO_QA/sample.ods>
Comment 3 Edwin Sharp 2013-12-16 10:10:12 UTC 
3 minutes 24 seconds to open.

AOO410m1(Build:9750)  -  Rev. 1548193
2013-12-07_04:10:48 - Rev. 1548790
Debian

Host/Kernel/OS  "aptosidbox" running Linux 3.12-4.slh.1-aptosid-amd64 x86_64 [ aptosid 2013-01 Ἑσπερίδες - kde-lite - (201305050307) ]
CPU Info        2x AMD Athlon II X2 250 clocked at [ 3000.000 MHz ]
Videocard       Advanced Micro Devices, [AMD/ATI] Cedar [Radeon HD 5000/6000/7350/8350 Series]     [  ]
Processes 125 | Uptime 4:04 | Memory 731.9/3960.1MB | HDD Size 500GB (8%used) | Client Shell | Infobash v3.46
Comment 4 Edwin Sharp 2013-12-16 10:23:10 UTC 
48 seconds with Calligra Sheets 2.6.4.
Comment 5 Rainer Bielefeld 2013-12-22 15:50:34 UTC 
Created attachment 82147 [details]
Statistics showing bad AOO performance

Currently AOO ist unusable for Spreadsheets with lots of data values and charts.
Comment 6 Armin Le Grand 2014-02-28 21:55:25 UTC 
Checked again to see if evtl. one of my last changes moved something. OOo3.3 needs 55s on my machine, AOO3.4 indeed much longer (stopped after 16 min). Looks like someone improved something; in the step to 3.4 probably one of the 'old' team who worked for calc... Do we still have the 3.3 sources somewhere...?
Comment 7 Rainer Bielefeld 2014-03-01 07:21:40 UTC 
Are
<http://archive.services.openoffice.org/pub/openoffice-archive/stable/3.2.1/> 
or
<http://www.openoffice.org/download/archive.html> (ASF also has an archive for 3.3.0)
useful for you?
Comment 8 Armin Le Grand 2014-03-17 14:42:46 UTC 
In which sense? I have a 3.2 and 3.3 for doing comparisons.
Comment 9 Rainer Bielefeld 2014-03-17 15:55:55 UTC 
(In reply to Armin Le Grand from comment #8)
> In which sense? I have a 3.2 and 3.3 for doing comparisons.

Hi, you asked for souce code, and those sites are containing files with a "src" in the name.
Comment 10 Armin Le Grand 2014-03-18 16:28:37 UTC 
Hi Rainer, thanks, I have the sources, too. The question is more which parts of changes may have caused that, sigh...