Add caching to permission management

[Piedone]

Is your feature request related to a problem? Please describe.

IPermissionProvider.GetPermissionsAsync() on all implementations is called on every admin request by AdminMenuPermissionService in OrchardCore.AdminMenu if any of the AdminMenu nodes have any permissions configured:

OrchardCore/src/OrchardCore.Modules/OrchardCore.AdminMenu/Services/AdminMenuPermissionService.cs

Lines 28 to 33 in 6312841

	foreach (var permissionProvider in _permissionProviders)
	{
	var permissions = await permissionProvider.GetPermissionsAsync();
	_permissions.AddRange(permissions);
	}

This can be a performance issue if the permission provider does anything more involved, like the one in Queries (before #16402), in Secure Media (what uses caching due to this), or Roles.

Also see https://github.com/OrchardCMS/OrchardCore/pull/15173/files#r1536280664 and #16402 (comment) for context.

Describe the solution you'd like

An approach, but surely not the best one, is to cache in every provider that does non-trivial work. like SecureMediaPermissions does. This is viable, and as that provider also shows, may be necessary due to the variety of how such caching, and especially cache invalidation should be done.

A better one would be to cache on a higher level, though then invalidation becomes an issue.

Once done, the caching in SecureMediaPermissions can be removed.

Describe alternatives you've considered

Keeping everything as it is for now, since this doesn't seem to be a big enough deal yet.

[github-actions]

We triaged this issue and set the milestone according to the priority we think is appropriate (see the docs on how we triage and prioritize issues).

This indicates when the core team may start working on it. However, if you'd like to contribute, we'd warmly welcome you to do that anytime. See our guide on contributions here.