Hi ANdreaT

Good news and bad news on the performance issue....

Bad news first:

It is the agilo plugin which causing the slowdown.

Good news:

a) It has nothing to do with agilo db schema or trac's simplicity etc.

b) We have a workaround and seems to work very well ( although, on a
project with _no_ agilo style tickets or linking... It was just two
trac instances, one with agilo enabled and the other one with agilo
disabled)

i) To investigate the performance issue, I tried using trac-admin
export command to see if there was any difference between the two
instances and there was none.

ii) Then I used Firebug plugin on firefox to see where the performance
difference was coming from. From the Net speed analysis, I found that
it was all the _static_ content that was causing the slowdown.

iii) A quick way to verify the above is to clear your web browser
cache and try loading the page (note the speed). Try it again the
speed would be slower ( if the server was configured the way we had)

iv) The way we had set things up _all_ requests went through trac/
mod_python handler and these included requests for company logo, trac
graphics, css ( almost anything under the "chrome" folder)

v) Our S/W guru, looked at the performance traces and said the work
around is as follows:

In our httpd.conf, he did the following changes

Alias /trac/chrome/common/ "/usr/lib/python2.5/site-packages/trac/
htdocs/"
Alias /trac/chrome/site/   "/var/tracdb/tracenv/htdocs/"

<Location "/trac/chrome/common">
    SetHandler None
</Location>
<Location "/trac/chrome/site">
    SetHandler None
</Location>


With the above changes, the static content did not go through
mod_python and hence the speed was vastly improved especially for the
agilo trac instance. Speed improvement was also seen for the non-agilo
enabled trac instance.

To make a long story, short, to improve agilo performance make sure
that the static content is server by apache and is not served by the
trac server

On _why_ exactly enabling agilo would slow down the serving of static
content, is left as an exercise to the reader :-)

Hope this helps.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Agilo for Scrum" group. This group is moderated by agile42 GmbH 
http://www.agile42.com and is focused in supporting Agilo for Scrum users.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/agilo?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to