Xon submitted a new resource:
Cache Permission Checks - Cache permissions blobs in redis
Read more about this resource...
Cache Permission Checks - Cache permissions blobs in redis
Reduce data fetched from MySQL and queries by bulk-fetching pre-computed sets from a Redis cache
XenForo permission-sets are stored per row per content-type, and there are a number of cases where this can result in a large number of rows being fetched or N+1 queries.
This add-on extracts the permission sets and caches the resulting set for by permission_combination_id/content_type.
This includes the special "global" permission set (as permission_combination_id/#user
)...
Read more about this resource...