Hi,
We try to use projeqtor but we find the application quite slow, either be for creating new projects, activities, entities, or moving them in the tree as subentities.
Why could this be ?
We do hesitate a lot to implement it in the team.
Many thanks in advance
Hello,
There are technical prerequisites for the server you're using for your instance of ProjeQtOr. Is your server meeting the expectations ?
On the links below, you can find at the bottom a description of our servers for hosting services, which work fine for all our customers, even with (very) large database and requests.
In french : https://www.projeqtor.org/fr/product-fr/technical-fr/51-setup-fr/33-product-prerequisites-fr
In english : https://www.projeqtor.org/en/product-en/technical-en/64-setup-en/412-product-prerequisites-en
Regards.
I thought it did with 4 cpu and 16 Go of ram...
I am also on posgresql, the database is not on the same server but it has 8 cpu and 32 Go of ram, and 50 go for storage
Hi,
Check network between php server and postgresql server.
ProjeQtOr is sending many queries.
So small latency between the servers may lead to long response time.
For instance, be sure to avoid DNS resolution between servers, use IP rather that DNS name.
Possibly use DB on same machine (our config on hosting server)
NB : check Demo ( https://demo.projeqtor.org ), you'll see what is the expected response time on correctly configured server.
Thank you. It's way faster indeed on the demo one...
Hi,
we are still in the process of understanding what's slowering our projeqtor instance. Just to try to save some time, is there some way of figuring out in the app the performance issues on the side of the php and database separately? Is there some kind of timer for them somewhere?
Thanks!
With log velvel to DEBUG, add in parameters.php
$debugPerf=true; // Add some timestamps and execution time at all debug lines
$debugQuery=false; // Debug all queries : trace Query and running time for each query