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

