Details

      Description

      Our monitoring tools report this query as taking a long time and being repeated multiple times on a login. It is causing unacceptable performance.

      SELECT PERMISSION_.PERMISSIONID AS PERMISSI1_27_0_, PERMISSION_.COMPANYID AS COMPANYID27_0_, PERMISSION_.ACTIONID AS ACTIONID27_0_, PERMISSION_.RESOURCEID AS RESOURCEID27_0_ FROM PERMISSION_ INNER JOIN ROLES_PERMISSIONS ON (ROLES_PERMISSIONS.PERMISSIONID = PERMISSION_.PERMISSIONID) WHERE (ROLES_PERMISSIONS.ROLEID = ?) AND (PERMISSION_.RESOURCEID = ?) ORDER BY PERMISSION_.ACTIONID ASC 21

        Attachments

          Activity

            People

            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                4 years, 21 weeks, 1 day ago