View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Kanban - quite slow - is it expected ? - Page 2 - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

[SOLVED] Kanban - quite slow - is it expected ?

More
12 Déc 2024 07:50 #7 by fxandrei
This is what i get:

=> 19049ms | page='kanbanViewMain.php' | destination='centerDiv' (server:18494ms, client:555ms)

Please Connexion or Create an account to join the conversation.

More
12 Déc 2024 09:09 #8 by babynus
So query is very long on server side (18s).
Just for 100 tiles, it is quite too much.
Check performance of your server.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
12 Déc 2024 10:43 #9 by fxandrei
The server is pretty solid. I dont think it has anything to do with the server.
I think it has something to do with the way it check for permissions. It seems to take to much.

Im now sure what i could check and how i should go about things.

Please Connexion or Create an account to join the conversation.

More
12 Déc 2024 12:07 #10 by fxandrei
After further investigation it seems that it has something to do with the mysql server.
Im using a mysql cluster.

I made a backup and clone the projeqtor instance, and configured it to use mysql server installed on the same instance, and it loads the kanban in 1-2 seconds.

I will investigate further.

Please Connexion or Create an account to join the conversation.

More
13 Déc 2024 07:43 #11 by fxandrei
Could you help me out with some hints about what i should actually check in relation with what is exactly happening when accessing kanban ?
I thinking that maybe some queries take longer or something !

Please Connexion or Create an account to join the conversation.

More
18 Déc 2024 10:04 #12 by fxandrei
So it turned out that the main problem was the fact that the main cluster was in a different location and that was the main cause of the slowdown.
I changed the clusterSet so that the main cluster is in the same location as the projeqtor instantance, and now the initial loading of all the tickets takes around 5 seconds, and its acceptable for now.
The following user(s) said Thank You: maxca

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.046 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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