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

Cleaning up permissions

Discussion in 'General XenForo Discussion and Feedback' started by Brogan, Jul 29, 2013.

  1. Brogan

    Brogan XenForo Moderator Staff Member

    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


    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.
  2. ibnesayeed

    ibnesayeed Well-Known Member

    Needed this! :)
  3. RoldanLT

    RoldanLT Well-Known Member

    Thanks again Brogan! (y)

Share This Page