Hi Stefano Thank you for your reply.
tiistai, 10. syyskuuta 2013 16.38.27 UTC+3 Stefano Rago kirjoitti: > > On Sep 3, 2013, at 11:37 AM, Torq <[email protected] <javascript:>> wrote: > > 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? > > Original production Trac was very slow without logging. I added the logging for the new debugging instance. Comparing performance between these two systems is not reliable since underlying hardware differs. > > 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? > > Ticket_custom has 13 308 rows List of all: nspname | relname | reltuples > --------------------+----------------------------+----------- > information_schema | sql_features | 650 > information_schema | sql_implementation_info | 12 > information_schema | sql_languages | 4 > information_schema | sql_packages | 10 > information_schema | sql_parts | 9 > information_schema | sql_sizing | 23 > information_schema | sql_sizing_profiles | 0 > public | agilo_backlog | 5 > public | agilo_backlog_ticket | 4182 > public | agilo_burndown | 4844 > public | agilo_burndown_data_change | 8475 > public | agilo_calendar_entry | 102 > public | agilo_contingent | 2 > public | agilo_link | 3022 > public | agilo_sprint | 115 > public | agilo_team | 1 > public | agilo_team_member | 15 > public | agilo_team_metrics_entry | 79 > public | attachment | 47 > public | auth_cookie | 0 > public | burndown | 0 > public | cache | 2 > public | component | 12 > public | enum | 34 > public | milestone | 98 > public | node_change | 72799 > public | permission | 64 > public | report | 22 > public | repository | 9 > public | revision | 13434 > public | session | 0 > public | session_attribute | 0 > public | session_attribute_jjs | 192 > public | session_jjs | 19 > public | system | 3 > public | ticket | 3829 > public | ticket_change | 34692 > public | ticket_custom | 13308 > public | version | 13 > public | wiki | 140 > (40 rows) > > 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? > I'll have to see about that. I might be able to access the data via Trac-admin user without the Radius in between. Torq -- -- 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.
