View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Slownesses - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

[SOLVED] Slownesses

More
11 Jan 2017 17:27 #1 by phil-bzh
Slownesses was created by phil-bzh
Hello,

I'm using ProjeQtOr on a local installation : Wamp server and MySQL database on a single (recent) PC, without internet access. I have one project with 300 activities (in 4 levels) and 10 ressources. Configuration : WAMPSERVER 3.0.6 64 bits (Apache 2.4.23, PHP 5.6.25 MySQL 5.7.14).

There are slownesses that are a bit annoying : the response time for each action is between 3 and 5 seconds (time between click and screen refresh). And there are many clicks to add an activity (it's normal)... So it takes me a lot of time creating / modifying activities. I must add that I'm NOT in auto-refresh mode for the planning and it's slow when I'm the only people working on the database.

I guess the database accesses are guilty...(?)

Does anyone have the same slownesses on this configuration ? Any solution ?

Thank you.

Please Connexion or Create an account to join the conversation.

More
11 Jan 2017 20:26 #2 by babynus
Replied by babynus on topic Slownesses
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.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
12 Jan 2017 09:37 - 12 Jan 2017 12:40 #3 by phil-bzh
Replied by phil-bzh on topic Slownesses
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 ?)
Attachments:
Last edit: 12 Jan 2017 12:40 by phil-bzh.

Please Connexion or Create an account to join the conversation.

More
14 Jan 2017 18:21 #4 by babynus
Replied by babynus on topic Slownesses
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

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
16 Jan 2017 19:06 - 16 Jan 2017 19:10 #5 by phil-bzh
Replied by phil-bzh on topic Slownesses
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.
Attachments:
Last edit: 16 Jan 2017 19:10 by phil-bzh.

Please Connexion or Create an account to join the conversation.

More
16 Jan 2017 19:31 #6 by babynus
Replied by babynus on topic Slownesses
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.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.045 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.