So everything seems to be pretty fast, except kanban.
When i click on it, it takes about 15 seconds to load.
I activated "script" in global settings, and watched the logs.
I see a lot of calls like this:
2024-12-06 15:41:36.982 ..... SCRIPT .... [3] getAccessControlRights(obj=Ticket #121)
2024-12-06 15:41:37.120 ..... SCRIPT .... [3] securityGetAccessRightYesNo ( menuName=menuTicket, accessType=update, obj=Ticket #122, user=)
2024-12-06 15:41:37.120 ..... SCRIPT .... [3] securityGetAccessRight(menuName=menuTicket, accessType=update, obj=Ticket #122, user=User #3)
2024-12-06 15:41:37.120 ..... SCRIPT .... [3] getAccessControlRights(obj=Ticket #122)
2024-12-06 15:41:37.126 ..... SCRIPT .... [3] securityGetAccessRightYesNo ( menuName=menuTicket, accessType=update, obj=Ticket #122, user=)
2024-12-06 15:41:37.126 ..... SCRIPT .... [3] securityGetAccessRight(menuName=menuTicket, accessType=update, obj=Ticket #122, user=User #3)
2024-12-06 15:41:37.126 ..... SCRIPT .... [3] getAccessControlRights(obj=Ticket #122)
2024-12-06 15:41:37.280 ..... SCRIPT .... [3] securityGetAccessRightYesNo ( menuName=menuTicket, accessType=update, obj=Ticket #123, user=)
2024-12-06 15:41:37.280 ..... SCRIPT .... [3] securityGetAccessRight(menuName=menuTicket, accessType=update, obj=Ticket #123, user=User #3)
2024-12-06 15:41:37.281 ..... SCRIPT .... [3] getAccessControlRights(obj=Ticket #123)
2024-12-06 15:41:37.286 ..... SCRIPT .... [3] securityGetAccessRightYesNo ( menuName=menuTicket, accessType=update, obj=Ticket #123, user=)
2024-12-06 15:41:37.287 ..... SCRIPT .... [3] securityGetAccessRight(menuName=menuTicket, accessType=update, obj=Ticket #123, user=User #3)
2024-12-06 15:41:37.287 ..... SCRIPT .... [3] getAccessControlRights(obj=Ticket #123)
2024-12-06 15:41:37.424 ..... SCRIPT .... [3] securityGetAccessRightYesNo ( menuName=menuTicket, accessType=update, obj=Ticket #124, user=)
So i have about 100-130 tickets, and it seems it calls these methods for each ticket:
- getAccessControlRights
- securityGetAccessRightYesNo
- securityGetAccessRight
Should it take this long to load ?
Is there something you think i should check ?
Hello,
The time is really long for only 100-130 tickets.
Can you tell me which version you are on? and which kanban configuration? (Display on kanban, display on tiles, kanban managment).
Have a nice day,
Maxca
Its 11.4.2 .
This is what i have selected on the kanban:
Display on kanban: nothing selected
Display on tiles:
- responsible
- priority
- urgency
- planned end date
Hello,
What type of kanban do you have? Which columns do you have? and how many?
Do you reproduce this slowness on the projeqtor demo site?
Maxca
It is a ticket status type kanban.
I have tickets added to a project that has a workflow with less columns (6 with backlog).
I have a new workflow defined for the project type used for the projects.
I only use the columns i need and allow all to change from one status to the other.
Can you please check browser console ?
You should have some log for kanbanView.php such as this
Please post result you get.
For information, this log shows that server side treatment longs 9s and client side took 4.2s, to display more that 1000 tickets on my laptop (results should be better with remote server)
This is what i get:
=> 19049ms | page='kanbanViewMain.php' | destination='centerDiv' (server:18494ms, client:555ms)
So query is very long on server side (18s).
Just for 100 tiles, it is quite too much.
Check performance of your server.
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.
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.
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 !
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.