Over time, our board has accumulated alot of individual based permissions. Subsequently the permissions cache has grown to around 500 MB in size. This has lead to issues of add-ons taking a long time to load, any time I update the software, I have to allow php to run scripts of 500MB in size otherwise the updates fail. Often have problems with permissions on usergroups etc. So I've decided to try a bulk cleanout by deleting all individual based permissions (user_id>0) from permission_entry, permission_entry_content and permission_combination via a sql script. I'll also be excluding any mods or staff from this clean up. A typical script would be "delete from xf_permission_entry where user_id>0 and user_id not in (select user_id from xf_user where is_moderator=1 or is_admin=1 or is_staff=1)". I've tested this on my test box, and it seems ok, but I'd like the opinion people who actually know the the permissions system at a high technical level before I proceed. And yes, I have run the permissions clean up task.