View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - database time connexion - ProjeQtOr
 
 

database time connexion

More
12 Mar 2015 16:38 #1 by swyngy
Good afternoon

When I login with an admin session I have the screen in attachements for exactly 60 seconds. Is there any value to modify in EasyPHP to decrease the connexion time?

I curently use EasyPHP on a local server

thks

Attachments:

Please Log in or Create an account to join the conversation.

More
12 Mar 2015 21:18 #2 by babynus
Replied by babynus on topic database time connexion
If your MySql server is local, try and change host name from "localhost" to "127.0.0.1".
Some MySql versions have name resolution issue, and this improve performance drastically.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
13 Mar 2015 08:29 #3 by swyngy
Replied by swyngy on topic database time connexion
Hi babynus,
I made this change long time ago.
When I connect with an admin account, I have to wait 60 seconds.
When I connect with other accounts, I don't have to wait.

Please Log in or Create an account to join the conversation.

More
13 Mar 2015 14:48 #4 by babynus
Replied by babynus on topic database time connexion
You can try to add some debugging :
Add this line in parameters.php
$debugQuery=true;
You'll have some trace (with execution time) of all requests.
this could help find where issue comes from.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
13 Mar 2015 16:24 #5 by swyngy
Replied by swyngy on topic database time connexion
I can't see why such a long delay:

2015-03-13 15:26:01
DEBUG
0.000584;select * from profile where id=1
2015-03-13 15:26:58
DEBUG
0.002011;select * from parameter where (idUser is null and idProject is null)

and

2015-03-13 15:26:58
DEBUG
0.000487;select id as id, name as name from indicatorable where (idle=0 ) order by indicatorable.name
2015-03-13 15:26:58
DEBUG
0.002346;desc alert
2015-03-13 15:26:58
DEBUG
0.000378;select * from alert where alert.idUser=1 and alert.readFlag=0 and alert.idle=0 order by id asc
2015-03-13 15:27:01 ===== TRACE ===== Cannot check Version at projeqtor.org/admin/getVersion.php
2015-03-13 15:27:01 ===== TRACE ===== Maybe allow_url_fopen is Off in php.ini...
2015-03-13 15:27:01
DEBUG
0.002504;select * from parameter where (idUser is null and idProject is null)

Please Log in or Create an account to join the conversation.

More
13 Mar 2015 16:31 #6 by babynus
Replied by babynus on topic database time connexion
GOT IT !!!

Connection is long because your server cannot connect to ProjeQtOt server to retrieve information on last deployed version.
So it waits for a Tiemout...

You just have to disable this functionality ("check for new version") in the global parameter screen.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.041 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

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