Many roles and performance

lifeisfoo

When I had the need to divide the users I installed the groups+memberships plugins. Now I need to restrict posting/viewing in certain section/applications, based on role. So I need to migrate from groups to roles (or, at least, create a role for each group...), and I'm wondering if having many roles (20-50) in Garden can lead to performance issues.

Can anybody report his experience?

businessdad

I don't think that having 50 roles can have a huge impact on the website. User's Roles are loaded at the beginning, and only a single User's Roles are processed at every rendering (unless some plugins do otherwise, but I can't see a reason why they should). From a database perspective, we are talking about 50 rows in a table, which is a negligible amount.

The question about Permissions is a bit more complex, as they are stored as columns in GDN_Permission table. The highest risk is to run out of columns, if too many permissions are registered.

businessdad

I don't think that having 50 roles can have a huge impact on the website. User's Roles are loaded at the beginning, and only a single User's Roles are processed at every rendering (unless some plugins do otherwise, but I can't see a reason why they should). From a database perspective, we are talking about 50 rows in a table, which is a negligible amount.

The question about Permissions is a bit more complex, as they are stored as columns in GDN_Permission table. The highest risk is to run out of columns, if too many permissions are registered.