Slow work with tasks

[JanBab]

Hi, when we work with tasks, EspoCRm works very slowly. Can it be speeded up? The picture shows Can it be speeded up? The picture shows relationships.

[yuri]

Hi,

What exactly is slow. Please provide more details. Is list view loading slow? Do you have cache enabled in Espo?

[JanBab]

When I open task the loading is about 9 seconds. Loading of other things is ok. Cache is enabled. Thare are about 180 tasks in database.

[yuri]

I have no idea, never encountered. Should be loading very fast.

[esforim]

Is it only Task that having issue?

Have you done the classic clear cache and clean and rebuild?

Have you look at your Server/CPU/HDD speed and system?

[JanBab]

Yes, only Task having problem.

I tried Clear Cache and Rebuild. It didn't help. What do you mean by "... and clean and ..."

The CPU load when opening a task is 20% at most. But there is only 4GB RAM. I don't know how big the database is, but the backup is about 5.5 GB. Could that be the problem?

[esforim]

https://docs.espocrm.com/administration/commands/

You can use the clear and rebuild in the Admin Guide, but there is no Documents for this. The above link talk about console/CLI.

5.5GB is not big, my is slightly larger and no issue.

Next you want to check is the HDD speed if CPU using so little.

Then you want to check if you add any new Relationship you add recently.

Or any Workflow, Formula or new Field you create or add.

Also see if you add any "Full Index" (Entity Manager > (Entity Name Task) > EDIT), this can really slow it down because it fail to index. Also remove a few "Text Filter Fields".

After this I exhaust any other potential issue and you can only keep digging and seeing. Also delete/temporary move all Task customization (Use your file manager on your server) and see if it help.

[JanBab]

I tried to delete all directory ...\espocrm\custom\Espo\Custom. Is it directory with customization? But it did not help.
I checked phpMyAdmin and it shows this.

[victor]

JanBab,

Please send a screenshots from:
- Administration > Entity Manager > Task > Edit.
- Administration > Entity Manager > Task > Relationships.

Also temporarily disable all formulas, BPMs and Workflows related to entity Task.

[JanBab]

We have not formulas, BPMs and Workflows.
Here are screenshots of
- Administration > Entity Manager > Task > Edit.
- Administration > Entity Manager > Task > Relationships.

[victor]

I have the same settings as you have in the screenshots and Task loads at normal speed. Maybe you made changes to the EspoCRM files? When did you first notice that tasks are loading slowly, after which actions?

[JanBab]

I made some new relationships in the past. It was between tasks, emails and companies. Since then, tasks take a long time to load. I didn't change the files.
Is there a list of added relationships?

[victor]

Please send the server /var/log/apache2/error.log and EspoCRM logs {ESPO_ROOT}/data/logs/.

[JanBab]

Here is Apache and EspoCRM logs ...

[victor]

- What version of EspoCRM do you have?
- What version of php do you have?
- Is it possible that you are using php 7.4.3 and later (8.1 for example) at the same time?