When working in large versioned spaces containing many pages, you might notice small performance decreases affecting the page tree's rendering time. There are a number of ways you can tune Confluence's cache to help solve this issue.
Specific cache tuning methods
The following tweaks will directly improve page tree performance:
- Content objects cache (com.atlassian.confluence.core.ContentEntityObject) should be set to at least 20-30% of the number of content entity objects in your system. To find the number of content entity objects, use the query select count(*) from CONTENT where prevver is null.
- Content Body Mappings cache (com.atlassian.confluence.core.ContentEntityObject.bodyContents) should be set to at least 20% of the number of content entity objects in your system.
- Space permissions by ID cache (com.atlassian.confluence.security.SpacePermission) should be set to the number of space permissions in your deployment (a good rule of thumb is 20 times the number of spaces). You can find the number of space permissions using the query select count(*) from SPACEPERMISSIONS.
General cache tuning
For more general tips on how to tune up your cache, see the official Atlassian docs.