inserting and updating users takes too much time

[ahmed almolla, modificado 8 Anos atrás.]

Hi All ,
we are using Liferay 6.0.5 on Glassfish ESB v 2.1 and MySQL 5.0
we are facing an issue where inserting and updating users takes too much time (about 20 sec ). currently we have arround 3000 user .

can any one help me please with this issue .


Thanks

[Ravi Kumar Gupta, modificado 8 Anos atrás.]

I would suggest you to check and debug what exactly is taking so much time. If a call to user update is taking much time, then you might want to connect to mysql and just run the same query on mysql to see if mysql is being culprit here.

Debugging should help you. If this is your custom code.

Try with this property in portal-ext.property and analyze which query is taking much time.
hibernate.show_sql=true

[ahmed almolla, modificado 8 Anos atrás.]

Actually I am not using any custom code .
We were using a monitoring tool and found that this prepared statement is the one that is taking all that time .

update User_ set uuid_=?, companyId=?, createDate=?, modifiedDate=?, defaultUser=?, contactId=?, password_=?,
passwordEncrypted=?, passwordReset=?, passwordModifiedDate=?, digest=?, reminderQueryQuestion=?, reminderQueryAnswer=?, graceLoginCount=?,
screenName=?, emailAddress=?, facebookId=?, openId=?, portraitId=?, languageId=?, timeZoneId=?, greeting=?, comments=?, firstName=?,
middleName=?, lastName=?, jobTitle=?, loginDate=?, loginIP=?, lastLoginDate=?, lastLoginIP=?, lastFailedLoginDate=?, failedLoginAttempts=?, lockout=?,
lockoutDate=?, agreedToTermsOfUse=?, active_=? where userId=?

[Ravi Kumar Gupta, modificado 8 Anos atrás.]

This seem to be a default liferay code which calls this query.. and this works just fine. Is there any problem with mysql?? I believe mysql should be working fine but user_ table may have some problem..

Try this.. check how many indexes are on User_ table. Are indexes proper or broken? Try reindexing once and make sure there is an index on userId field.