Details

    • Similar Issues:
      Show 5 results 

      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

        Activity

        Hide
        Aniceto P Madrid added a comment -

        Matthew
        Can you check if this issue is still in 6.2.0m4? Here can you download bundles http://sourceforge.net/projects/lportal/files/Liferay%20Portal/6.2.0%20M4/
        Is Oracle running on a quick server or not? Have you run Oracle SQL advisor for it to suggest what indexes to create? Do they improve the performance? Are statistics gathered regularly? How many users and permissions do your portal have?
        Thanks

        Show
        Aniceto P Madrid added a comment - Matthew Can you check if this issue is still in 6.2.0m4? Here can you download bundles http://sourceforge.net/projects/lportal/files/Liferay%20Portal/6.2.0%20M4/ Is Oracle running on a quick server or not? Have you run Oracle SQL advisor for it to suggest what indexes to create? Do they improve the performance? Are statistics gathered regularly? How many users and permissions do your portal have? Thanks
        Hide
        Matthew O. Smith added a comment -

        We have since upgraded to Liferay EE and the slowness problem has gone away.

        Show
        Matthew O. Smith added a comment - We have since upgraded to Liferay EE and the slowness problem has gone away.
        Hide
        Aniceto P Madrid added a comment -

        This issue is not reproducible.  This issue can be closed

        Show
        Aniceto P Madrid added a comment - This issue is not reproducible.  This issue can be closed

          People

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

            Dates

            • Created:
              Updated:
              Resolved:
              Days since last comment:
              2 years, 8 weeks, 6 days ago

              Development

                Structure Helper Panel