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

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

More
12 Dec 2024 07:50 #7 by fxandrei
This is what i get:

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

Please Log in or Create an account to join the conversation.

More
12 Dec 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 Log in or Create an account to join the conversation.

More
12 Dec 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 Log in or Create an account to join the conversation.

More
12 Dec 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 Log in or Create an account to join the conversation.

More
13 Dec 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 Log in or Create an account to join the conversation.

More
18 Dec 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 Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.053 seconds

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.