Details
-
Suggestion
-
Resolution: Fixed
-
None
Description
The cache labelled "Permission Set Collections in Content Entity Objects" (com.atlassian.confluence.core.ContentEntityObject.contentPermissionSets) currently has no size specified. This makes it use the default size of 1000 entries. This can fill up quite quickly, (eg in our intranet) and ContentPermissionSets are usually quite small. It would probably be worth making this cache at least "medium" if not large.
Some customers are reporting very large numbers of sql queries like:
select contentper0_.CONTENT_ID as CONTENT_ID__, contentper0_.ID as ID__, contentper0_.ID as ID0_, contentper0_.CONT_PERM_TYPE as CONT_PER2_0_, contentper0_.CONTENT_ID as CONTENT_ID0_, contentper0_.CREATIONDATE as CREATION4_0_, contentper0_.LASTMODDATE as LASTMODD5_0_ from CONTENT_PERM_SET contentper0_ where contentper0_.CONTENT_ID=?
This would probably be cut down by increasing the size of the aformentioned cache like appropriately to confluence-coherence-cache-config.xml (and confluence-coherence-cache-config-clustered.xml):
<cache-mapping> <cache-name>com.atlassian.confluence.core.ContentEntityObject.contentPermissionSets</cache-name> <scheme-name>medium</scheme-name> </cache-mapping>
Attachments
Issue Links
- is related to
-
CONFSERVER-11816 Improve performance by specifying a larger size for the UI Templates cache
- Closed