Hi Torq, On Sep 3, 2013, at 11:37 AM, Torq <[email protected]> wrote:
> Viewing sprint backlogs, sprints and editing sprints is very slow. > Viewing a sprint from backlog can take 15 seconds. > > We have over 100 sprints in agilo_sprint (past and future) > > Single click on ticket from Sprint Backlog generates about 20 000 loglines > like those below. > Essentially every team member's name and email is checked for every sprint. > Did you already compare these performances with logging turned off? > Removing team from past sprints speeds things up. > This seems like a hack, so I'm interested to know what we are doing wrong > here. > > Missconfiguration or bad data in db? What is the approximate size of the "ticket_custom" table? How many tuples are there? In general, could you please provide the tuple count for all of the tables in the environment's database? > > We've used Trac&Agilo for over 4 years and the slowness has crept on us > slowly. > Just to debug this slowness I've installed a new instance on Ubuntu v12 64bit > server on Hyper-v with > binary_agilo-1.3.10_PRO-py2.7.egg > postgressql-9.1-main.log > and Radius for authentication. > > DB was imported from the old trac&Agilo installation. Would it be possible to compare performances in a condition where Radius is disabled / bypassed? Stefano Rago -- -- Follow Agilo on Twitter: http://twitter.com/agilofortrac Please support us by reviewing and voting on: http://userstories.com/products/8-agilo-for-scrum http://ohloh.net/p/agilo-trac http://freshmeat.net/projects/agiloforscrum You have received this message because you are subscribed to the "Agilo for Trac" Google Group. This group is focused on supporting Agilo for Trac users and is moderated by Agilo Software GmbH <http://www.agilosoftware.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 --- You received this message because you are subscribed to the Google Groups "Agilo for Trac" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.

