1. Home
  2. Portal
  3. User creation slow with full document library

User creation slow with full document library

G C, modified 4 Years ago.
User creation slow with full document library
New Member Posts: 8 Join Date: 10/8/20 Recent Posts
Hi, I have performance problems creating/editing a user from Liferay Administration section using liferay-ce-portal-7.0-ga5 and MySql db.
Enabling hibernate query logging I have noticed that during user creation Liferay execute a lot of slow queries on resourcepermission table.  I have a full document library with folders and files that increase resourcepermission records. With 6028 record on resourcepermission table, user creation time is around 16 seconds.
Do you have suggestions? Can someone help me? How can I improve execution time?

Thanks.
thumbnail
Olaf Kock, modified 4 Years ago.
RE: User creation slow with full document library
Liferay Legend Posts: 6441 Join Date: 9/23/08 Recent Posts
G C:

Hi, I have performance problems creating/editing a user from Liferay Administration section using liferay-ce-portal-7.0-ga5 and MySql db.
Enabling hibernate query logging I have noticed that during user creation Liferay execute a lot of slow queries on resourcepermission table.  I have a full document library with folders and files that increase resourcepermission records. With 6028 record on resourcepermission table, user creation time is around 16 seconds.
I can think of a few options:
  1. check if this is reproducible in the latest release - your version is quite outdated (2017). At a minimum check GA7 (with the mandatory patch, that you should have installed long time ago)
  2. As you're missing the patch, check if your server mines bitcoin on the side, and causes the slowness this way. 6028 entries doesn't sound like a big database to me.
  3. Check if all indizes are there in the database (e.g. there's a separate indexes.sql file in the SQL download)
G C, modified 4 Years ago.
RE: User creation slow with full document library
New Member Posts: 8 Join Date: 10/8/20 Recent Posts
Thanks for your support, I will try patch installation and  I will let you know
G C, modified 4 Years ago.
RE: User creation slow with full document library
New Member Posts: 8 Join Date: 10/8/20 Recent Posts
I have tried liferay-ce-portal-tomcat-7.0-ga7-20180507111753223 having the same problems.

I have tried last version of liferay, liferay-ce-portal-tomcat-7.3.4-ga5-20200811154319029 and problem seems to be resolved (10.400 record, 1/1.5 second).

 Thanks Olaf for your support