Hi all,

I just changed from using the stand-alone tracd to Apache 2.2 + latest
mod_python (as described here http://trac.edgewall.org/wiki/TracModPython)
which works like a charm. Yes, I know I should have implemented
mod_wsgi but that is currently avaliable for Python 2.6+ and the
necessary svn bindings not available for anything newer than Python
2.5 so...

Anyway, we had Python 2.5 installed on our Windows 2003 server, so I
installed and configured Apache 2.2 + mod_python 3.3.1 in less than 15
minutes. This combo is direct replacement for the standalone tracd
without any reconfiguration of the Trac/Agilo environment or any other
hassles. From before we're running Postgre SQL as the database
backend.

Apache 2.2 + mod_python gives noticeable better performance on
displaying wiki pages, creating tickets, displaying list of tickets
etc than tracd. It aslo seem to handle multiple users better. Typical
response times is now less than 1 second for the wiki pages and 2-3
seconds to display "Active tickets", 677 in all when this is written.
(The HW is a quad core 3Ghz 16GByte RAM dedicated svn and Trac/agilo
server.)

But then, displaying our product backlog is another story. It still
takes 12 to 20 seconds to show... So, I cloned the DB onto our test
server to perform some database performance tests by enabling debug
logging and turned on SQL statement logging as described
http://trac.edgewall.org/wiki/TracLogging

Displaying the Product backlog makes Agilo to execute more than 9000
SQL SELECT statements ... !
Some room for optimizations?

;-D Hans

-- 
Follow Agilo on Twitter: http://twitter.com/agiloforscrum
Please support us by reviewing and voting on: 
http://userstories.com/products/8-agilo-for-scrum 
http://ohloh.net/p/agilo-scrum 
http://freshmeat.net/projects/agiloforscrum

You have received this message because you are subscribed to
the "Agilo for Scrum" Google Group. This group is focused on
supporting Agilo for Scrum users and is moderated by
Agilo Software GmbH <http://www.agiloforscrum.com>.

To post to this group, send email to [email protected]
To unsubscribe from this group, send an email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/agilo

Reply via email to