Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

database time conne...
 
Notifications
Clear all

database time connexion

7 Posts
2 Users
0 Reactions
7,779 Views
(@swyngy)
Posts: 32
Active Member
Topic starter
 
[#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


 
Posted : 12 Mar 2015 18H38
babynus
(@babynus)
Posts: 14966
Main Contributor 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.


 
Posted : 12 Mar 2015 23H18
(@swyngy)
Posts: 32
Active Member
Topic starter
 

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.


 
Posted : 13 Mar 2015 10H29
babynus
(@babynus)
Posts: 14966
Main Contributor 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.


 
Posted : 13 Mar 2015 16H48
(@swyngy)
Posts: 32
Active Member
Topic starter
 

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)


 
Posted : 13 Mar 2015 18H24
babynus
(@babynus)
Posts: 14966
Main Contributor 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.


 
Posted : 13 Mar 2015 18H31
(@swyngy)
Posts: 32
Active Member
Topic starter
 

Ok problem solve
Thks


 
Posted : 16 Mar 2015 12H57
Share:

Scroll to Top