Resource icon

Cache Permission Checks [Paid] 1.5.0

No permission to buy ($35.00)

Xon

Well-known member
Xon submitted a new 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...
 
This was a semi-private add-on that has been used to decent affect on a few very busy sites with large number of forums and/or user-group counts. It absolutely isn't for everyone.
 
Xon updated Cache Permission Checks with a new update entry:

1.2.1 - Feature update

  • Require XenForo 2.2+
  • Require php 7.2+
  • Support using SV/InstallerAppHelper to enable this add-on to execute during XF installer app and to prevent this add-on being disabled during add-on upgrades
    • Add-on not yet publicly released
  • If installed require the following at the minimum versions:
    • Can Warn Staff v2.2.1+
    • User Essentials v4.2.14+
    • Collaborative Resources v1.3.2+
    • Collaborative Threads v2.7.5+

Read the rest of this update entry...
 
Xon updated Cache Permission Checks with a new update entry:

1.4.0 - Feature update

This update vastly improves the speed for changing permissions when a large number of user-groups and nodes exist. Uninstalling is now disruptive, as all permissions need to be rebuilt.

  • Require redis cache v2.15.4+
  • Reduce memory usage when multiple user's permissions are loaded
  • Fix possible race condition when loading permissions from redis
  • Dynamically handle any 3rd party XF permission handlers
  • CLI command xf-rebuild:sv-cached-permissions can be...

Read the rest of this update entry...
 
On SpaceBattles, permission rebuilds when touching the "Registered Users" group used to take about 3-4 minutes, and now takes a few seconds. This is a fairly large Quality of life improvements for admins touching permissions.
 
Top Bottom