Hi,
I have a performance issue with ProjeQtOr.
For example, when I want to move a task on a small project, it's very slow on my instance instead of projeqtor's online demo.
For example, on my instance it's take 30655ms on ProjeQtOr online demo : this same action take 153ms !
How can I improve that ?
I'm on ProjeQtOr V11, PostgreSQL 16, PHP 8.2, Apache2.4
Server (I have put Postgresql on the same server) : debian 12 with 4 CPUs, Intel(R) Xeon(R) Gold 6234 CPU @ 3.30GHz, 12go RAM
Thanks for help,
Florian
“Be a yardstick of quality. Some people aren't used to an environment where excellence is expected.” ~ Steve Jobs
"...and while some may see them as the crazy ones, we see genius, because the ones who are crazy enough to think that they can change the world, are the ones who do." ~ Think Different
Does anyone have the same problem with postgresql?
Is ProjeQtOr performance supposed to be the same between a mysql and a postgresql database?
Or is there a slowdown with PostgreSQL?
Is PostgreSQL still maintained by ProjeQtOr?
Thank you in advance for your answers.
Best regards,
“Be a yardstick of quality. Some people aren't used to an environment where excellence is expected.” ~ Steve Jobs
"...and while some may see them as the crazy ones, we see genius, because the ones who are crazy enough to think that they can change the world, are the ones who do." ~ Think Different
For example,
In order to move up or move down a task in the planning composed of 5 tasks, it's take between 10 and 15 secondes minimum ! Sometimes more...
“Be a yardstick of quality. Some people aren't used to an environment where excellence is expected.” ~ Steve Jobs
"...and while some may see them as the crazy ones, we see genius, because the ones who are crazy enough to think that they can change the world, are the ones who do." ~ Think Different
Difficult to analyse performance issue that are not produced on demo.
Best way will be for you to insert some "debugLog()" into the code to trace what happens.
As long as I know, there is not performance issue with PostgreSql.
Compared to MySql, I find it a bit slower on single tasks, but better on high volumetrics or high load, but is is in a small part only, never 30x slower.
En poursuivant votre navigation, vous acceptez le dépôt de cookies tiers destinés au bon fonctionnement et à la sécurisation du site (gestion de session, reCaptcha) et à une analyse statistique anonymisée des accès sur notre site (Google Analytics). Si vous vous inscrivez, les informations que vous fournirez ne seront jamais divulguées à un tiers sous quelque forme que ce soit. En savoir plus
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.
Support us on Capterra
