Performance Issue on User update on any Entity.

[deepsinghal29@gmail.com]

"Assigned User" updates takes time to save on Task. This is happening with Task, and another custom entity. No Before save script or workflow or process flow on Tasks

[lazovic]

Hi deepsinghal29@gmail.com,

Please provide error logs of your EspoCRM instance (located in {ESPO_ROOT}/data/logs/ directory).
Also, server error log may be useful.

I also recommend that before filling out the Assigned User field in Task, first open the browser console (press the F12 key) and go to the Console tab. After that, fill out the Assigned User field and click on the Save button on Task record in EspoCRM, then check if any errors appear in the browser console.

[deepsinghal29@gmail.com]

I tried all these but no errors are captured. I tried Log level ot DEBUG as well. Still no logs. Not sure how to trace the performance logs

[lazovic]

deepsinghal29@gmail.com,

You can also try checking the Slow Query Log of the database: https://dev.mysql.com/doc/refman/8.0...query-log.html

At least there will be complete information about the query, which leads to a delay when saving the record.