Confluence Very Slow

Jahsie

Hello,

We recently upgraded from 3.5.13 to 4.3.

Everything works, but it is really slow. We have upgraded all 4.x compatible plugins, disabled those that are not. We have also re-run both indexes. We upgraded the servers memory to 4.5 gb from 2.5, and assigned 1280mb to confluence's tomcat service. According to the system information page, we have ab out 40% of our heap memory, and 50% of our perm gen memory free.

But even the most basic pages are taking between 20-30 seconds to load. The performance on 3.5.13 was never this slow, is there something on the configuration end that we can do to improve performance?

Niles

Jahsie

Helllo,

I wanted to loop back on this one. I opened a ticket with Atlassian (who are excellent by the way).

Basically: we use the Zen Foundation Plugin for our confluence instance, and there was a missing index in our db tables that was killing page load times (it was taking 25-30 seconds to load a page). The Zen plugin was contantly checking for new drafts instead of referncing an index. Finding each page with a draft only a couple of milliseconds, but added up across all the spaces we had.

Atlassian Response:

There seem to be several problems here, all of which are compounding and causing a high page load time:

• Confluence does not cache database calls when getting page drafts. I have attached a patch that I'd like you to try out that should resolve this particular issue.
• The Zen Foundation plugin is calling findDraft a lot.
• The database latency seems a little high. The startup logs claim it is 16ms. Is there something you can do so that the latency between the application server and database isn't so high? Ideally we'd like to see something in the 0-9ms range.
• Can you run the following query to give us an idea of how many unsaved drafts you have?

  select count(*) from CONTENT where CONTENTTYPE='DRAFT' and DRAFTPAGEID='0'

They created a patch which I beleive will be in future version of Confluence that creates an index.

Niles