• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Cleaning up permissions

Brogan

XenForo moderator
Staff member
#1
As it hasn't been mentioned yet, 1.2 comes with a new function to clean up permission combinations which are no longer in use.

It can be found in ACP -> Tools -> Rebuild Caches

upload_2013-7-29_9-34-27.png

If you have a lot of user groups and permission combinations and have made changes over time, moving members in and out of groups, etc. then there may be some redundant data left in the database.

During testing on my site, there were 109 permission combinations with 71 unused and no longer needed.
After running the clean up, this was reduced to 38 permission combinations with 0 unused.
So a significant reduction in the total number of combinations.

Running this clean up task may yield significant speed improvements when creating new (private) nodes for example.

The queries were included in an earlier beta release upgrade script so anyone who has upgraded since B3 will already be benefitting from this improvement.