Issue 57008 - performance: Slow saving and loading as ODF
Summary: performance: Slow saving and loading as ODF
Status: CLOSED FIXED
Alias: None
Product: Writer
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.2
Hardware: PC All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: michael.ruess
QA Contact: issues@sw
URL: http://www.jurk-family.de/public/down...
Keywords: oooqa, performance
Depends on:
Blocks:
 
Reported: 2005-10-31 07:58 UTC by tjurk
Modified: 2013-08-07 14:44 UTC (History)
5 users (show)

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


Attachments
Fixed document (387.92 KB, application/vnd.oasis.opendocument.text)
2008-05-26 09:48 UTC, Oliver Specht
no flags Details
proposed fix (14.08 KB, patch)
2009-02-04 15:09 UTC, Oliver Specht
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description tjurk 2005-10-31 07:58:16 UTC
Got the sdw file provided in Issue 54338 loaded on the latest release of OO2.
1. Saving it as ODF takes a very long time (not acceptable).
2. Saving it as sdw stucks (or looping). Tried about 8 hours, nothing happened.
BTW: Is there any quality assurance regarding the new releases (i found a lot of
bugs in the released OO2 version)!!!!!!
Why do i provide a file for testing and (nearly) nothing happens.
Comment 1 michael.ruess 2005-10-31 08:27:21 UTC
Reassigned to ES.
Comment 2 eric.savary 2005-10-31 10:05:05 UTC
Reassigned to HI.
Comment 3 eric.savary 2005-10-31 10:11:06 UTC
Wrong reassignment, sorryy!
Comment 4 hwoarang 2005-12-09 00:27:20 UTC
Can reproduce with OOo 2.0.1rc3 WinXP SP2

I can't save as ODF, as this type is not available here (should be?) in Writer.

When I try to save as SDW Writer hangs. No progress bar for saving the file.
After 5 minutes without no signal of activity, OOo returns.

Adding the URL for the file in question.

Hwoarang
Comment 5 tjurk 2005-12-15 09:09:07 UTC
Tried it w OO2.0.1RC4: Saving as ODF still takes about 18 (EIGHTEEN) Minutes
(W2k prof. en). 
Definitly too long and NOT acceptable!
Seems to be a bug in the sxw/odf engine.
No files are touched during saving (sometimes HDD LED lit 'cause OO is updating
some temp files). Must be a problem in the engine itself.

Could someone dig into the code and try to figure out what happens?
Could it be the trueth, that such a great product if NOT capable to handle
"real-world" documents? I don't think that OO should be limited to work only
with files of < 10 pages!!!
Comment 6 jack.warchold 2006-02-01 16:26:56 UTC
confirmed on SRC680_m154

saving in my system least 15 minutes. maybe  this issue depends on the same 
error as issue 54338

reassigned to os
lowered prio to p3
set target OOo later (same reason as in issue 54338)
Comment 7 jack.warchold 2006-02-01 16:28:36 UTC
additional informations

open and save (as sxw) least less then 3 minutes in a SO7pp1
Comment 8 Oliver Specht 2006-02-02 06:51:55 UTC
Should be fixed in the next patch
Comment 9 lars.nooden 2006-04-06 19:15:59 UTC
This is also the case for OS X and applies to both Writer and Calc (haven't
tested the others).  One work around would be to have the save run in the back
ground.  Currently the slowness is a major impediment, espcially for those of
use who do frequents saves. (Years of using Windows have left their mark and
even on better platforms I still reflexively hit save every time I pause in
writing.)

Here is one medium-sized document that can take about two minutes to save even
on a 1GHz G4:
http://www.kursing.no/oo/Generell_Writer_Calc.odt
Comment 10 Oliver Specht 2006-05-18 12:44:11 UTC
Target changed to 2.x
Comment 11 tjurk 2006-05-18 12:59:22 UTC
Can this be the trueth, that this is not a bug of high priority????
and assigned to a lter release (not for the first time)
I can not agree!
Pls. fix the bug immediately!!!!
Comment 12 ggabriel 2006-07-01 05:12:47 UTC
Please correct the saving time in OOo 2.x it's just unacceptable, is even slower than in the 1.x 
series! 
Between this issue and its slow start time OOo is placing itself out of the game. 
Please Sun do something! 
 
Comment 13 tjurk 2006-10-29 07:14:39 UTC
Just checked OO 2.0.4: Saving just costs 4 (FOUR) Minutes !!!!
Is it the truth, that nobody can fix such a major bug.

THIS SW IS NOT SUITABLE FOR PROFESSIONAL APPLICAIONS !!!!!

Within months nothing has been done, just did some assignments and moved the
milestones again and again to the future.
Comment 14 hwoarang 2006-10-29 15:21:08 UTC
tjurk:
can you update the download url  ? the file is not available.

thank you.

Hwoarang
Comment 15 tjurk 2006-10-29 16:15:06 UTC
Zipped file now avail (again) for download:
http://www.jurk-family.de/public/download/OO2Test/QuickStartOO2Test.zip
Good luck
Comment 16 Oliver Specht 2006-10-30 08:21:05 UTC
The problem seems to be the amount (more than 21000!) of index entries in this
file and the handling of these entries at the UNO API of the writer. 
Comment 17 ggabriel 2006-10-31 17:13:12 UTC
This problem is not exclusive of Writer. 
I have a spreadsheet where I keep my personal account with something like 40 sheets and 4 
graphs, and it takes 40 seconds everytime I (or the automatic backup) save the file. 
It's just *very* unproductive. 
 
I've just converted the file to .XLS and tried it in an old version of Excel (97) I have around, and it 
took only 1 second to save the same file (!!!). How can that be? 
Calc "thinks" for about 20 seconds before doing the actual file saving, and then it takes another 20 
secs. to write the file to disk. 
 
I know all the benefits ODF is supposed to have, etc. But at this price (=time, remember?) I do not 
know much serious people who'd be willing to bet on it. 
 
Comment 18 tjurk 2007-04-01 07:35:14 UTC
OO 2.2 released, still absolutely nothing happened. Still takes about 5 Minutes
on a modern PC to save/load/import the file. 
Could someone pls. pls. pls. raise the priority?
If there anybody responsible to fix that bug?
Can this be the truth that most of the OO users are working with simple
documents of only a few pages? What about the millions of students and their
diploma?
The bug has been provided approx. 2 years ago, unbelievable !!! 
I still need to work on this document using OO 1.1.5 !!!!
Comment 19 Mathias_Bauer 2008-01-11 12:50:52 UTC
target 3.0
Comment 20 Mathias_Bauer 2008-04-25 11:19:00 UTC
target 3.x
Comment 21 tjurk 2008-04-26 06:03:20 UTC
Unbelievable. Always moving pending work to the future.
It seems that you are not interested in fixing the bug.
Why do you develop new releases if the old bugs are not fixed?
Comment 22 Mathias_Bauer 2008-04-26 11:55:54 UTC
It seems that you don't know anything about software development, so I apologize
your rude tone.

If an application of the size of OOo won't provide new features before all bugs
have been fixed it would never get any new features and would be dead as a dodo
in less than a year. So bug fixing must follow priorities derived from
relevance, severity, effort, visibility and some other criteria. As we have very
limited resources we have to follow these priorities very strict or we will risk
not to do the things we think are important.

You should see that a performance problem that happens only for a particular
kind if document doesn't have a very high priority. Having a document with
>21000 index entries is something that most users will never see in their life.
There are a lot of more issues (and missing features!) that are much more
important for much more users. 

os has pointed out what the performance problem is. What he didn't write here is
that this would require a rework of the used API that will last for several
weeks. This is something that we can't invest here at the moment.
Comment 23 tjurk 2008-05-23 07:16:28 UTC
FYI: Developer since > 20 Years for mission critical and industrial applications.
Regarding the amount of index entries: What about diplomas? Students out of the
focus of OO?
Ok, let's come back on the technical stuff: How can i get rid of the index
entries within the document to check what happens and to figure out what a
possible wirk around could be?
Comment 24 Oliver Specht 2008-05-26 09:48:55 UTC
Created attachment 53934 [details]
Fixed document
Comment 25 Oliver Specht 2008-05-26 10:24:25 UTC
->tjurk: The attached document should work for you now. 
The problem is the automatic creation of index entries with the concordance
file. While updating the index all entries should be removed at first and then
re-created. 

->od: In case there's a concordance file used the update mechanism of alphabetic
indexes removes all automatically generated index marks and creates new ones
flagged as automatic. This 'automatic' attribute is not stored and is not part
of the ODF spec. 

Reassigned to OD to get it added to ODF 
Comment 26 tjurk 2008-05-28 08:40:23 UTC
-> os thanks for the fix. But i need to fix other documents too. Could you pls.
provide a way to do this myself
-> os which version did you use to create the new file. My 2.4.0 OO says that a
newer version was used.
-> os the Index-Markers in the document (formatted text, Index-Marker tooltip on
Mouse-Over) you provided still exist. Any way to remove them?
Comment 27 Oliver Specht 2009-02-04 14:50:19 UTC
Grabbing issue to fix the performance problem
Comment 28 Oliver Specht 2009-02-04 15:09:56 UTC
Created attachment 59924 [details]
proposed fix
Comment 29 Oliver Specht 2009-02-11 10:41:23 UTC
Fixed in cws os108
Comment 30 Oliver Specht 2009-05-15 09:06:53 UTC
Should have been cws os128

Reassigned for verification
Comment 31 joerg.skottke 2009-05-25 12:14:30 UTC
Verified.
Comment 32 thorsten.ziehm 2009-07-20 14:54:15 UTC
This issue is closed automatically and wasn't rechecked in a current version of
OOo. The fixed issue should be integrated in OOo since more than half a year. If
you think this issue isn't fixed in a current version (OOo 3.1), please reopen
it and change the field 'Target Milestone' accordingly.

If you want to download a current version of OOo =>
http://download.openoffice.org/index.html
If you want to know more about the handling of fixed/verified issues =>
http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues
Comment 33 thorsten.ziehm 2009-07-20 15:35:36 UTC
Sorry this issue was wrongly closed. This issue will be reopened automatically.
And will be set after that back to fixed/verified.
Comment 34 thorsten.ziehm 2009-07-20 15:40:05 UTC
Set to state 'fixed'.
Comment 35 thorsten.ziehm 2009-07-20 15:44:18 UTC
Set back to state 'verified/fixed'.

Again. Sorry for the mass of mails.
Comment 36 michael.ruess 2009-10-01 19:08:52 UTC
Checked in DEV300m60.
Comment 37 socrat3000 2009-12-21 09:16:02 UTC
Downloaded and installed the 3.2 release candidate (OOO320m8 Build:9472), and I
assure you that the bug is still there.
Comment 38 socrat3000 2009-12-21 09:18:39 UTC
Downloaded and installed the 3.2 release candidate (OOO320m8 Build:9472), and I
assure you that the bug is still there.
Comment 39 michael.ruess 2010-01-05 12:27:22 UTC
mru->socrat3000: please file a new issue and attach your sample document; it
looks, that it is a very different problem.