Loading permissions is slow

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: No Longer Reproducible
• Affects Version/s: 6.0.6 GA
• Fix Version/s: 6.2.0 CE M4
• Component/s: Infrastructure, Infrastructure > DBs
• Labels:
  • community-verifier
  • login
  • performance
  • permissions
• Environment: Glassfish 3.1.1 ; Oracle
• Similar Issues: Show 5 results ; ;

  LPS-18574	Document Library Slow Performance
  LPS-11904	Slow response when loading Date Input component in IE 7
  LPS-12037	gallery images images larger then 1m slows down server
  LPS-16599	Managing Permissions in document library / pages / folders is very slow
  LPS-1477	Remove duplicate icon.pngs that slow down page load

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

[Aniceto P Madrid]

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

[Matthew O. Smith]

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

[Aniceto P Madrid]

This issue is not reproducible.  This issue can be closed