How can you Improve Greenhopper Performance?

[Matt Robbins]

We are having some problems with the performance of Greenhopper. We have a project with 4000 issues. Whenever we go to the planning board it takes several minutes to come up. We are working on the suggestions that are given here at this link: http://confluence.atlassian.com/display/GH041/GreenHopper+FAQ#GreenHopperFAQ-HowcanIimprovetheperformanceofGreenHopper

Has anyone faced this same problem? If so what did you do to fix the problem?

Thanks

[JamieA · Accepted solution]

Seeing as you're using Orable, applying a composite index as per this: https://jira.atlassian.com/browse/GHS-1398 made massive differences for our installation.

[Matt Robbins]

Thanks Jamie this is a great suggestion. We are looking into this.

[Matt Robbins]

We built the composite index and that made a big difference. From what we could tell the memory wasn't really the issue at least the stats. But we are looking at doing this as well.

Thanks everyone for you help.

Matt

[Kenn White]

If you're in Windows, you may have readjusted your on-screen size at some point using Control+Mouse Wheel. For whatever reason, the planning board slows down DRAMATICALLY if you're not in the native font size. Hold Control+Mouse Wheel to default the screen presentation size and see if that doesn't fix it. It worked for me - instantly.

This is 100% reproducable, by the way. Try it yourself.

[Jon Cotter]

I would start by throwing RAM at the problem... (assuming you have RAM to spare)

-XX:MaxPermSize=512m -Xms4G -Xmx4G

[Nic Brough -Adaptavist-]

The physical RAM isn't a huge worry, it's the RAM in use Jon was asking about. You can see that on the Administration -> System info screen.

[Matt Robbins]

Yah we watched that as I was making the request and there wasn't really any impact. We also checked the cpu. Everything looked fine for both of those. However at the end of the day the memory, when we looked, was using every bit we had. So we are monitoring this as well to see if we need to increase it.

[Matt Robbins]

I am working on trying to find out how much ram we are using. We are running the server on a VM. We have about 30 project not all active. Probably around 25 active with variablility on how actively used. If I were to guess on the number of total issues across all project I would say close to 40k.

The project I am working on where we are seeing the slowness has around 6000 issues with around 2000 resolve/closed.

[Jon Cotter]

How much RAM? Also... how many issues do you have in the entire installation... and how many projects (ballpark, exact numbers arent needed)

[Matt Robbins]

It is Oracle 11g. We have looked at the memory and cpu when I hit the process and that doesn't seem to be the problem.

[JamieA]

what database?