Forum

database time conne...
 
Notifications
Retirer tout

database time connexion

7 Posts
2 Utilisateurs
0 Reactions
7,744 Vu
(@swyngy)
Posts: 32
Active Member
Début du sujet
 
[#2239]

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


 
Posté : 12 Mar PM 18:033
(@babynus)
Posts: 14952
Membre Admin
 

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.


 
Posté : 12 Mar PM 23:033
(@swyngy)
Posts: 32
Active Member
Début du sujet
 

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.


 
Posté : 13 Mar AM 10:033
(@babynus)
Posts: 14952
Membre Admin
 

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.


 
Posté : 13 Mar PM 16:033
(@swyngy)
Posts: 32
Active Member
Début du sujet
 

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 http://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)


 
Posté : 13 Mar PM 18:033
(@babynus)
Posts: 14952
Membre Admin
 

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.


 
Posté : 13 Mar PM 18:033
(@swyngy)
Posts: 32
Active Member
Début du sujet
 

Ok problem solve
Thks


 
Posté : 16 Mar PM 12:033
Share:
Retour en haut