Issue 124445 - AOO Basic execution slow
Summary: AOO Basic execution slow
Alias: None
Product: General
Classification: Code
Component: scripting (show other issues)
Version: 4.0.0
Hardware: All Windows 7
: P4 Minor (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: performance
Depends on:
Reported: 2014-03-17 07:25 UTC by Rainer Bielefeld
Modified: 2014-03-20 06:31 UTC (History)
3 users (show)

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

Sample Document with Macro (11.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-03-17 07:25 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Rainer Bielefeld 2014-03-17 07:25:24 UTC
Created attachment 82879 [details]
Sample Document with Macro

Steps how to reproduce with server installation of "AOO 4.1.0-Beta – German UI / German locale - [AOO410m14(Build:9760)  -  Rev. 1573601 2014-03-03 17:47:48]" on German WIN7 Home Premium (64bit)", own separate user profile:

You will need at least 1 additional Version (OOo 3.3.0 or more early) what you can execute on your PC in parallel.

0. For All 2-3 OOo test Versions enable macro execution
1. Open a copy of attached sample document in each OO version (I tested
   OOo 3.3.0, AOO 4.0.0, AOO 4.1.0 Beta)
2. Arrange windows of OO versions side by side so that together they fill
   all screen width, disable Auto spell check if necessary
3. Arrange focus for each OOo window so that all show more or less the same
   part of the sheet, Button and cell G20 visible, Click G20
4. Click in Windows 'Start Macro' button for all version in quick sequence
   > In all OO versions rotqtion demo starts
5. Open a different application (browser or so) do avoid effect of active
   OO window
6. After 5 Minutes check results. 
   > All OO Versions should show a message with time in seconds what have
     been required in that version to execute the macrl. My Results:
     OOo 3.3.0:      131 s
     AOO 4.0.0:      161 s
     AOO 4.1.0 Beta: 161 s
More or less the same result running the macros in the different versions one after the other So result shows that execution in pre AOO versions was 20% faster.

I see reduced performance starting with AOO 4.0.0, was still ok with 3.4.1
Comment 1 Rainer Bielefeld 2014-03-17 08:55:35 UTC
Currently I con't know whether that is a general problem or only a problem with a particular function in the example
Comment 2 Oliver-Rainer Wittmann 2014-03-19 12:16:10 UTC
I can confirm the described observation on my Windows 7 system.
- OOo 3.3.0: 139s
- OOo 3.4.Beta: 167s
- AOO 4.0.0: 170s

I performed two further runs, but before I switched off the Sidebar in AOO 4.0.0 and restarted AOO 4.0.0. The Sidebar contains a control which constantly reflects the text rotation angle.
- OOo 3.3.0: 144s, 146s
- OOo 3.4.Beta: 173s, 167s
- AOO 4.0.0: 138s, 145s

In a further run I included AOO 3.4.1 as well
- OOo 3.3.0: 147s
- OOo 3.4.Beta: 166s
- AOO 3.4.1: 152s
- AOO 4.0.0: 150s

and two more again with Sidebar on in AOO 4.0.0
- OOo 3.3.0: 146s, 148s
- OOo 3.4.Beta: 171s, 172s
- AOO 3.4.1: 160s, 158s
- AOO 4.0.0: 180s, 181s

It looks like as if AOO 3.4.1 and AOO 4.0.0 are almost as fast as OOo 3.3.0, but AOO 4.0.0's additional functionality - the Sidebar feature - takes some time to update the user interface.
It also looks like that the OOo 3.4 Beta contains a performance degradation.

Can you confirm my observation?
What are your results, when you switch off the Sidebar in AOO 4.x?
Comment 3 Rainer Bielefeld 2014-03-20 06:31:43 UTC
(In reply to Oliver-Rainer Wittmann from comment #2)
I did only 2 tests for each situation with 4.0.1 (WIN), it seems I can confirm your result that sidebar has influence.

(a) I normally have sidebar active, macro execution took 160s
(b) Closing Sidebar with menu 'View -> Siedbar' without influence, again 160s
(c) Exit -> Relaunch AOO (sidebar still inactive): 130s
(d) Only activate -> deactivate Sidebar, and macro needs 160s again
    (second test: 140s)

The sample is small, and I did the tests in parallel to my work, so may be other CPU loade has influence, but suspect that sidebar rotation angle view slows down Macro execution is substantiated by these tests.

I will do some more tests with more stable test conditions and other macro loops, soon.