Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-10142

Improve performance by specifying a larger size for the Content Permission Set cache

    XMLWordPrintable

Details

    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    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

          Activity

            People

              akazatchkov Anatoli
              don.willis@atlassian.com Don Willis
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: