Lots of duplicate SQL queries being made on umbracoUserGroup

Questions
1

Hi,

I’m profiling my start page on Umbraco v13 and 25% of the load time is dedicated to SQL calls and I can see there are a lot of duplicate SELECT queries against the umbracoUserGroup table. I’m seeing this in New Relic transaction traces and also the MiniProfiler in Umbraco.

These calls are also made on our frontend instance that has the backoffice endpoints disabled and hence I’m not authenticated. Question is, where are these calls coming from? We aren’t directly calling IUserService.GetUserGroupByAlias ourselves..

SELECT [umbracoUserGroup].[id] AS [Id], [umbracoUserGroup].[userGroupAlias] AS [Alias], [umbracoUserGroup].[userGroupName] AS [Name], [umbracoUserGroup].[userGroupDefaultPermissions] AS [DefaultPermissions], [umbracoUserGroup].[createDate] AS [CreateDate], [umbracoUserGroup].[updateDate] AS [UpdateDate], [umbracoUserGroup].[icon] AS [Icon], [umbracoUserGroup].[hasAccessToAllLanguages] AS [HasAcces...
2

Hey johan,

these queries are triggered internally by Umbraco’s permission and public-access checks. Even frontend, anonymous requests may require Umbraco to evaluate user groups to determine content access. In v13, these calls are not fully cached per request, which is why you see repeated SELECT queries

1 Like
3

I see, thanks!

4

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.