It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can you Improve Greenhopper Performance?

Matt Robbins Sep 26, 2011

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:

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


9 answers

1 accepted

1 vote
Answer accepted
JamieA Sep 26, 2011

Seeing as you're using Orable, applying a composite index as per this: made massive differences for our installation.

Matt Robbins Sep 26, 2011

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

Matt Robbins Oct 11, 2011

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.


0 votes
JamieA Sep 26, 2011

what database?

0 votes
Matt Robbins Sep 26, 2011

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.

0 votes
Jon Cotter Sep 26, 2011

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

0 votes
Matt Robbins Sep 27, 2011

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.

0 votes
Matt Robbins Sep 27, 2011

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.

0 votes
Nic Brough [Adaptavist] Community Leader Sep 27, 2011

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.

0 votes
Jon Cotter Sep 27, 2011

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

-XX:MaxPermSize=512m -Xms4G -Xmx4G

0 votes
Kenn White Aug 21, 2012

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.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in Off-topic

Disney Live Action Reboots: Are you for or against?

Happy Friday Everyone! Today marks the international release of Disney's live action version of the animated classic Aladdin. I know that this movie was met with some controversy of over cast...

214 views 22 10
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you