Need effiecient way to determine pub-view setting for large sites
Description
When users navigate to the Resources tool in sites with many resources OR when users expand-all in sites with many resources, it results in many many queries to the realms tables, checking to see if the anonymous role has "content.read" permission for the realm related to each resource and folder. We need a way to reduce the impact of these queries on database performance.
When users navigate to the Resources tool in sites with many resources OR when users expand-all in sites with many resources, it results in many many queries to the realms tables, checking to see if the anonymous role has "content.read" permission for the realm related to each resource and folder. We need a way to reduce the impact of these queries on database performance.