Issue 81901 - Improve the performance of the templates update feature.
Summary: Improve the performance of the templates update feature.
Status: CONFIRMED
Alias: None
Product: General
Classification: Code
Component: code (show other issues)
Version: OOo 2.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-09-24 15:35 UTC by banker
Modified: 2017-05-20 10:47 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description banker 2007-09-24 15:35:57 UTC
After upgrading from OOo 2.02 to 2.30 I've noticed that opening menus and
dialogs has become dramatically slower! While browsing menus with the mouse
there a noticeable delays before a new menu is opening. This delay is smaller
when opening a menu for the second time but there is still no "smooth" working
for the user. 

This performance regression becomes obvious (and really annoying) when opening
the dialog File -> New -> Templates and Document. In our environment the 2.02
needed ca. 15s to display the template list for the first time (201 files in 10
directories) and ca. 1s for subsequent times. The 2.2x and the 2.30 need
threefold that time (~ 45s) for the first invocation and ca. 35s for subsequent
invocations.

IIRC OOo 2.00 had the same problem and it was fixed by an improvement described
in issue #54784 ( http://www.openoffice.org/issues/show_bug.cgi?id=54784 ).
Comment 1 shaunmcdonald131 2007-09-24 23:18:21 UTC
Can you please give some information about your system? OS, RAM, Hard Disk, etc. Are the templates 
stored locally or on a network?
Comment 2 banker 2007-09-25 08:20:34 UTC
We have a Citrix-Farm with Windows 2003 Server SP2. The blade systems have 3 GB
RAM and two 72 GB SCSI drives in a RAID 1 array. OOo is installed locally on
each Citrix server and the user configuration is on a network share in the
user's home drive (z:\ooffice). The templates are on a different network share
(m:\...).

I have used a test system to verify this behaviour. It's reproducable at will.
With the 2.02 the whole responsiveness of the application is much better.
Opening menus and scrolling within them is smooth whereas with 2.2x or 2.3 the
application seems to hang sometimes.

We had many complaints of our users and so we downgraded back to 2.02. Now
everything is fine again.
Comment 3 carsten.driesner 2007-09-25 08:31:06 UTC
cd->jsk: Could you please check this issue. That's the first time I hear that
there is a performance problem in a citrix env.
Comment 4 banker 2007-09-25 09:32:11 UTC
The problem exists not only under Citrix. I'm using the 2.30 on my admin pc.
It's a Windows XP system and OOo and the user configuration files are installed
locally. Opening the same template path is faster as with the 2.30 under Citrix
but not as fast as the 2.02:

Citrix with 2.30:      45s / 10-15s (first/subsequent)
Windows XP with 2.30:  12s / 6s
Citrix with 2.02:      10s / 1s
Comment 5 joerg.skottke 2007-11-27 09:07:42 UTC
Creating test environment...
Comment 6 joerg.skottke 2007-11-27 10:05:03 UTC
Ok, cannot reproduce with my simplified test scenario - templates and documents
open in less than 3 seconds on both office versions.

Need to try harder.
Comment 7 joerg.skottke 2007-11-27 10:30:43 UTC
After reading this report a couple of times it appears to me that the real
problem is that the read-performance on the share holding the templates has
become slower with recent builds.

We have two independent network shares - user directory and template directory -
that need to be parsed which is a performace killer per definition. However,
this does not explain the performance regression...

To mav

Comment 8 joerg.skottke 2007-11-27 12:49:05 UTC
Ok, used our internal exchange drive to reproduce and yes, in 2.0.2 loading the
directory structure took a few seconds (3 in my case) where 2.3.1 takes more
than 22 seconds.

The reason for the incredible speed of the 2.0.2 compared to a 2.3 is that the
redirected template file hierarchy is not read at all - the dialog just pops
open but does not show any usable content. This is a bug that apparently has
been circumvented by placing custom templates into the shared template
directory. However, the implementation in 2.0.2 is buggy and does not work at
all under certain conditions. Nothing is read so the dialog is fast as lightning.

What remains is the problem that it really takes ages to read in all templates
from a slow network drive. We should improve on that. 

@mav can you try to find out whether we can get this fixed for 2.4? This is a
place that could potentially affect anybody using the product in networked
environments.

Setting target (preliminary) to 2.4. Confirming issue.
Comment 9 mikhail.voytenko 2008-01-08 11:48:38 UTC
As JSK has already mentioned, this is no real regression. In the old versions
the template update just did not work correctly, so it just did not need the
time. From other side the performance of the feature should be improved anyway.
I am changing the title accordingly.

The templates update has nothing to do with the performance of the menus opening
in general. It is only related to scenarios "File/New/Templates and
Documents..." and "File/Templates/...".

Setting the target to 3.0.
Comment 10 mikhail.voytenko 2008-06-02 07:01:13 UTC
Not enough resources - moving to 3.x
Comment 11 Marcus 2017-05-20 10:47:30 UTC
Reset assigne to the default "issues@openoffice.apache.org".