Ticket #2570 (closed defect: fixed)

Opened 2 years ago

Last modified 1 year ago

Dashboard page slowing down as repository grows, trac gets more tickets

Reported by: asloan7@gmail.com Assigned to: richardw, khundeen
Priority: normal Component: TracMetrixPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description (Last modified by khundeen)

Dashboard page slowing down as repository grows, trac gets more tickets. Not sure which is exactly causing the problem, time to time the components and see what is taking so long.

It is taking about 5 seconds to generate the page now. We have about 450 tickets (that's not many) and our repository is not that big either, only about 8 months old, not a huge team.

Attachments

Change History

03/19/08 19:37:59 changed by fermulator

We're experiencing the same slowdown (however we just installed the TracMetrixPlugin to a mature trac and repository (2 years old)). The amount of computation and database access is rather large, so obviously as we have more data the stats would take longer to generate.

If performance cannot be enhanced, I would suggest some sort of caching system. The sever could setup a cron job to generate daily stats each day (for example), and the users could view the cache instead of waiting for a live stat request.

(NOTE: If cache was implemented, users should still have the option to refresh stats now and re-generate the cache so-to-speak.)

04/19/08 12:00:41 changed by khundeen

My original idea was to create extra database table to store the calculated statistic. However, I didn't have time to implement that part.

Time is limited at my end. I anticipated the performance issue as well but this will requires a lot more work.

Could you tell me how many tickets you have in the system and how long did it take you to load the dashboard?

Which page take more time to load? Milestone or Project dashboard?

05/08/08 11:33:49 changed by angrod@t-online.de

Hi, we have more than 3700 tickets in the system and the project dashboard takes up to 10 minutes to load. The milestone dashboard is faster, under one minute to load.

Nice plugin if the loading performance of the project dashboard can be enhanced.

08/24/08 23:07:03 changed by richardw

  • owner changed from khundeen to richardw.
  • status changed from new to assigned.

I have also seen this performance problem with a trac database of ~1000 tickets, ~3000 revisions.

I'll start by creating a function to build large trac databases and use it to measure the rendering time of the dashboard page. I'll then try and identify where performance could be improved.

04/02/09 22:11:32 changed by khundeen

  • owner changed from richardw to richardw, khundeen.
  • description changed.

04/03/09 18:37:22 changed by anonymous

I haven't found solution to this problem but I did make the Ticket metrics/backlog optional in r5474. Without calculating these metrics, it won't take a long time to load.

04/03/09 19:38:08 changed by khundeen

  • status changed from assigned to closed.
  • resolution set to fixed.

I considered this ticket fixed for now. I will create new ticket when I have chance to really get into performance tuning. Metrics calculation does take a lot of cpu power. There is no easy way around this, beside disabling it all together.

Add/Change #2570 (Dashboard page slowing down as repository grows, trac gets more tickets)




Change Properties
Action