Issue 83712 - oocalc 2.3 very slow for simple operations
Summary: oocalc 2.3 very slow for simple operations
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.3
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2007-11-16 21:39 UTC by airbete
Modified: 2013-08-07 15:15 UTC (History)
2 users (show)

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


Attachments
Example file (21.86 KB, application/vnd.sun.xml.calc)
2007-11-16 21:41 UTC, airbete
no flags Details
Example file 2 (15.13 KB, application/vnd.sun.xml.calc)
2007-11-17 15:31 UTC, airbete
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description airbete 2007-11-16 21:39:17 UTC
oocalc 2.3 on Fedora 8 is very slow compared to oocalc 2.0 on Fedora 6.

Please see the attached file. There is a small macro in it (a math function) but
it can be turned off as it doesn't affect the following results.

(*) right-click on column "N" (or any other) and choose "insert columns"

Then 
1) in oocalc 2.3 on Fedora 8 it takes 13 seconds to do (*)
2) this time is reduced to less than 1 second if AutoCalculate is turned off.
3) in oocalc 2.0 on Fedora 6 it takes less than 1 second to do (*) whether or
not AutoCalculate is on.

(**) turn off AutoCalculate (via F9 or the menu)

4) in oocalc 2.3 on Fedora 8 it takes 7 seconds to accomplish (**)
5) in oocalc 2.0 on Fedora 6 it takes less than 1 second to do (**)

Packages installed:

On the Fedora 8 box:
openoffice.org-calc-2.3.0-6.6.fc8.rpm

On the Fedora 6 box:
openoffice.org-calc-2.0.4-5.5.24.rpm

Remark. The larger the worksheet, the longer the times in 1) and 4). For some of
my worksheets, it takes an hour to add a single column in oocalc 2.3 while it
takes a second or two in oocalc 2.0. It looks like oocalc 2.3 is recalculating
everything thousands of times when it is not necessary.

AB.
Comment 1 airbete 2007-11-16 21:41:13 UTC
Created attachment 49702 [details]
Example file
Comment 2 airbete 2007-11-17 15:30:53 UTC
I have attached another file (test2_slow_oocalc23.ods) which shows an even
stranger behavior.

1) right-click on column L and select delete columns: 6 seconds (very long).
2) undo (ctrl-z): < 1s (that's ok)
3) right-click on column L and select insert column: < 1s (that's ok)
4) undo (ctrl-z): 8 seconds (much too long)
5) select columns L and U (with ctrl), right-click on column U and select delete
columns: < 1s !! (that's ok)
Comment 3 airbete 2007-11-17 15:31:35 UTC
Created attachment 49705 [details]
Example file 2
Comment 4 caolanm 2007-11-19 11:56:50 UTC
I can confirm that it's real real slow with the "vanilla" 2.3.0 rpms
Comment 5 frank 2007-11-23 12:25:54 UTC
Hi Eike,

seems to be yours.

Frank
Comment 6 ooo 2008-07-17 18:08:00 UTC
I cannot reproduce this using a DEV300m24 Linux/x86 build, all operations
mentioned to be slow above take ~1s or less.

@airbete, @cmc: could you please confirm?

Thanks
  Eike
Comment 7 airbete 2008-07-17 18:36:25 UTC
The problem seems to be gone with
openoffice.org-calc-2.4.1-17.4.fc9.i386
on Fedora 9. Thanks.
Comment 8 caolanm 2008-07-17 19:45:49 UTC
Indeed, fast in 2.4.1 again. *shrug*, the problem has "gone away"
Comment 9 ooo 2008-07-18 12:07:15 UTC
Of course this was solved having invested a vast amount of mythical man months ;-)
Thanks for verifying.
Comment 10 ooo 2008-07-18 12:07:41 UTC
Closing.