On Thu, 2006-03-16 at 19:06 +0000, Robert Hunter wrote: > On Thu, 2006-03-16 at 12:47 -0600, Russ Brown wrote: > > We have been using trac for some time now with very few problems. > > However, recently the timeline just started crawling along, and is > > starting to affect our work. > > > > Now, two things happened at around about the same time that could have > > caused this, so I'd like some ideas on which one it might be and how to > > go about resolving it. > > > > The first problem is that someone in our did a commit that was over a > > gigabtye in size. It was full of log files that didn't need to be in VC, > > so I dumped and reloaded the repository, replacing the massive checkin > > with a dummy revision that just added a blank file. I also had to do the > > same for a later revision that was an SVK pull from trunk. Now, > > everything works absolutely fine from the point of view of people using > > SVN/SVK (though some had to rebuild their depots as they'd already > > synced the big change down). So the repository is fine. I'm wondering if > > this has anything to do with Trac's revision caching. Is this possible, > > and if so would I be able to clear the cache for these revisions and > > have Trac re-cache them? > > I believe the command is: > $ trac-admin resync /your/trac/env >
Thanks! I knew I remembered seeing something like this before. OK, I've run it but unfortunately its not cured the problem. To investigate a little further I've played a little with the timeline filters. If I show everything but Repository checkins it is very fast, but if I show only checkins it is very slow. I'm only showing 7 days of history too, and this only used to take a couple of seconds at the most. Now it takes something like 39 seconds. If its not the repository cache, is there anything else in the repository rebuilding that could have caused this? If not, it must be the upgrade that has slowed everything down Perhaps there needs to be an index somewhere that the trac upgrade script didn't add? (I just did a diff of my db's schema against a fresh trac instance schema and didn't spot any missing indexes). So I'm at a loss. Has anything significant changed in the way in which the timeline is queried for and constructed/rendered? -- Russ _______________________________________________ Trac mailing list [email protected] http://lists.edgewall.com/mailman/listinfo/trac
