Hi, we have performance issues after upgrading to 7.18.5
When users act in the system, a lot of queries of the type are generated:
SELECT
[SubjectSchemaUId],
[CanRead],
[CanAppend],
[CanEdit],
[CanDelete]
FROM
[dbo].[SysEntitySchemaOperationRight] WITH(NOLOCK)
WHERE
EXISTS (
SELECT
1
FROM
[dbo].[SysAdminUnitInRole] WITH(NOLOCK)
WHERE
[SysAdminUnitInRole].[SysAdminUnitId] = @P1
AND [SysAdminUnitInRole].[SysAdminUnitRoleId] = [SysEntitySchemaOperationRight].[SysAdminUnitId])
AND [SysEntitySchemaOperationRight].[Position] = (
SELECT
MIN([Position])
FROM
[dbo].[SysEntitySchemaOperationRight] [MinRightPosition] WITH(NOLOCK)
WHERE
EXISTS (
SELECT
1
FROM
[dbo].[SysAdminUnitInRole] WITH(NOLOCK)
WHERE
[SysAdminUnitInRole].[SysAdminUnitId] = @P2
AND [SysAdminUnitInRole].[SysAdminUnitRoleId] = [MinRightPosition].[SysAdminUnitId])
AND [MinRightPosition].[SubjectSchemaUId] = [SysEntitySchemaOperationRight].[SubjectSchemaUId])
ORDER BY
[SysEntitySchemaOperationRight].[ModifiedOn] DESC
A similar problem occurred during the update last time, when we updated to the system version 7.17.2.
Then they gave us additional dlls and told us to add the key key="UseOptimizedSchemaOperationRightLevelSelect" value="true"
Do you have a solution for the problem for version 7.18.5?
Like