Issue 72822 - slow performance loading 560k Excel file
Summary: slow performance loading 560k Excel file
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
URL:
Keywords: oooqa, performance
Depends on:
Blocks:
 
Reported: 2006-12-20 17:32 UTC by timsoft
Modified: 2013-08-07 15:14 UTC (History)
5 users (show)

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

Attachments
xls sheet takes almost 6mins to load (561.50 KB, application/vnd.ms-excel)
2006-12-20 17:35 UTC, timsoft 		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 timsoft 2006-12-20 17:32:27 UTC 
loading a sample .xls spreadsheet with 13 sheets and only simply formula takes
almost 6mins on win 98 or win XP with 2000/2400+ athlon xp cpu and 512mb ram.
if the document is saved as an .ods file, it takes about 4-5 seconds to load.
I will add the problem spreadsheet when this is submitted.
Comment 1 timsoft 2006-12-20 17:35:34 UTC 
Created attachment 41608 [details]
xls sheet takes almost 6mins to load
Comment 2 timsoft 2006-12-20 17:55:22 UTC 
once the spreadsheet has been saved as .ods file and loaded again into calc,
saving it as an excel 97/2000/xp file takes 2-3minutes, and loading that new
calc-created xls file still takes about 5 minutes
There must be a bug somewhere to need 1000000 instructions to decode each byte
of the xls file or calc created xls file...
Comment 3 aziem 2006-12-21 07:32:19 UTC 
Yes, it does take a long time on OOo 2.1 Linux.  On my system (AMD Athlon XP
3000+), about 7 minutes.  Maybe CWS hr39 helps (?), but even a 75% reduction
would be a long time.
Comment 4 aziem 2006-12-21 07:37:29 UTC 
Excel Viewer 97 takes < 3 seconds, so OOo takes two orders of magnitude more.  ;)
Comment 5 frank 2007-01-16 14:14:47 UTC 
Hi Daniel,

the file task a long time to load, I thought it could be the Charts and stripped
them in Excel from the file, bt no luck. Please have a look at this one.

Frank
Comment 6 utomo99 2008-01-04 12:26:07 UTC 
as frank say it maybe chart problems, 

and iha already working with CWS chart15
I hope it reduce the problems, and faster for this issue too

Thanks
Comment 7 IngridvdM 2008-01-15 19:38:53 UTC 
This is fixed already with the new chart in OOo 2.3.
While loading the attached document with OOo 2.2 takes about 3,1 minutes,
loading it with OOo 2.3 takes only 3,4 seconds.
Just for information: Loading it with current master ooh680m2 takes 3,1 seconds.
Comment 8 IngridvdM 2008-01-15 19:42:06 UTC 
->Frank, please verify in OOo 2.3.
Just for information: when checking the performance on the current master, take
at least ooh680m2 containing CWS chart15.
Comment 9 frank 2008-02-11 13:35:40 UTC 
found integrated on master OOHm5 using Solaris, Linux and Windows builds