First check that access to database is set to 127.0.0.1 and not localhost.
Also try to comment xdebug extension in php.ini (not only set enabled=false)

If it's not source of issue, add debugQuery=true ; and set debugLevel to 3 in parameters.php.
Then play use case and post here lig file.

Hello thank you for your answer.

I have commented all lines beginning with xdebug in wamp file php.ini. There was a great improvemnt for planning calculation duration (30 seconds to 10 seconds : great !) and just slight improvements for adding / deleting activities.

So I went in projeqtor/files/parameters.php where :

• I've found $paramDbHost = '127.0.0.1' (good)
• I've changed LogLevel from '2' to '3'
• I've added $debugQuery = true
• I've also added $debugLevel = 3 (but I think you meant LogLevel and not debugLevel)

My use case :
1) connection (error message in log file because I'm not connected to the internet, I'm interested in ways of avoiding it, but it is not my matter for this post beacuse I suppose it happens only at startup)
2) going to planning and copying an activity,
3) modifying fields of this activity (status , assignment, duration, work...) with mandatory saving between these actions
4) disconnecting

Log file joined, if you see something interesting (I saw line insertions in table "history" => maybe it would be faster if I stop historying ? If you think so => how ?)

1) You're right, it is $logLevel and not $debugLevel
2) error on connection (for admin only) is due to try and retreive value for last ProjeQtOr version number on our servers. You can disable the feature on global parameters to avoid loggin error
3) db access seem correct in log file

Can you :
a) disable debug logging (logLevel=2)
b) disable emailing (empty smtp server in global parameters)
c) open browser console
d) run use case
e) post here content of console

Hello,

I've done stages a to e and here is the content of the console on Internet Explorer 11.0.29.

(I must say I have added one step at the end of my use case : calculate planning, for 8 seconds 🙂 )

Sincerely,
Phil.

It seems you have a quite large database.

Display of planning : how many projects / lines of gantt do you display ?

Object details : it seem yhou always display history, which takes 3 second on server side.
=> try and set display history "on request" in your user parameters.

hello,

As I told in my first post, I have more or less 800 activities in one project.

To answer your question (but I'm not sure of understanding it), the activity tree levels are more or less developped : when I work on the planning maybe the trees are developped to display 50 to 100 activities (but I'm not sure the time for displaying planning depends on trees developped or not ?).

About "history" :

• In user parameters display history is set to "no"
• As you suggest, I set it to "on request, through specific button". But it shouldn't change anything regarding speed, compared to "no" ?
• So comes the question : how can I guest wether history is active or not ? 🙂

Sincerely

It really seems your server is very slow.
You should investigate this way.

Analysis of performance of your system is out of scope of this forum and would be difficult to do remotely.

Hello,

OK, thank you for your help. You've helped me much and I understand you can't help me more.

Last question : is it possible to disable history (not saving it in the database, not only not displaying it as you suggested) ?

For others users, here what helped me getting ProjeQtOr faster : comment all lines beginning with xdebug in wamp file php.ini

I a user know how to get faster with a WAMP server (last version installed locally on a brand new PC), I will be happy if he can add information on this post 🙂

Sincerely.

is it possible to disable history (not saving it in the database, not only not displaying it as you suggested) ?

No, disabling history save is not possible, and it won't change much things.