As an addendum to the previous post, I've done some more cleaning up, and JIRA is now 12 times faster on the average measurement.
Label # Samples Average Min Max Login 3 18 13 29 LoginFBrowse 10 41 10 184 Get issue 903 590 21 7792 Dashboard 9 14836 10006 18698 LazyLoaderPortlet 9 632 [...]
Over the last few months JIRA performance has tanked, but gradually. Difficult to think of any particular inflexion point, just more users, projects and issues.
I had a number of changes I had in mind to help:
Application server DBMS type and location Caching for static content Reducing numbers of projects, groups etc. Optimising indexes. [...]