Difficult to investigate with so little information.

First, whan you say "access to activities" do you mean get the list or get the detail of one activity ?

The same for listing activities and show info.

Even when i update activites info, it need about 8 seconds.

Thanks.

I can confirm this is not normal.
For instance you can test http://perfs.projeqtor.org, with about 10000 activities.
Listing all activities is less than 3 seconds.
Getting detail for 1 activity is abot 1 second.

Check log file for errors of too verbuous logging.
You can possibly check log files for mysql and activite the "long query logging" to check which queries are long.
Check your CPU, and HDD accees.
Maybe it's just configuration of mysql allowing too small cache...
It's difficult to help more without investigating on the machine.

I have found a lot long query like this:

2017-07-11 08:25:40.642 ----- DEBUG ----- 5.208813;select * from history where (refType, refId) in ( ('x',0), ('Activity', 8855), ('ActivityPlanningElement', 9975)) order by operationDate desc, id asc

Can you help me to fix it please?

Dear Babynus

In attachment is log file, its record only time for update name of activites.

To load activites info now its just take 4 seconds. Then i change name of activities and save, it took 50 seconds.

Please help.

Hi,

I cannot see any long query in the log file...

About previous query report, try and disable display of history (change user parameter) : is it better ?
Check indexes existing on table history, what do you have ?

All history in user parameter is set to NO.

HISTORY table have indexes: id, refType, refId.

When i insert or delete activities, its usually take 15 seconds; to load Planning screen take over 2 minutes.

Regards,