Performance for TestLink tree structure

[stef-lhm]

We use TL for several years now. Our actual version ist 1.9.14.
In some of our project (each project more tahn 1000 testcases) the tree structure in testexecution causes many problems, cause it take more than 20 seconds to generate this.
is there any chance to come to 4 or 5 seconds for generating a testexecution page?
I know there is a bug with in the tree strucutre cookie, but maybe there are other things i can do?

[stef-lhm]

How to make loading of the tree structure in test exec. faster (1.9.14)? Is there anybody who can help?

[stef-lhm]

We did the update to TestLink 1.9.19 and we still have the problem, that the loading of the treestructur in testexecution needs to much time.
Anybody else, who have a problem like this?
Are there any hints how to fix this problem?

[stef-lhm]

It takes 30 to 40 seconds to build up the treestructure

[stef-lhm]

This effect happens in small projects with less testcases, too.
I think that most of this delay time happens in the browser. But even in new browsers this problem exists. Maybe the problem with the large cookie?

[stef-lhm]

After searching on what happens on the database, we know a bit more about the performance problem.
Testlink opens a session on DB. After that, nothing happens. This session is in sleep state for more than 10 seconds. Then the 3 queries come in. it takes 1-2 seconds to do the queries.
So it takes 20-40 seconds from klicking "testexecution" in TestLink until we can see the complete treestructure. The question is, why is the session for such a long time in sleep state? Is anybody out there who knows about that problem and knows how to fix it?
Thanx

[stef-lhm]

just to add two other facts,
- we use MySQL 5.7.24
- the session will be closed immediately after finishing the quieries

so the problem is open the session - !!!SLEEP!!! - query/close session

[stef-lhm]

In my userlog, i found out, that execDashboard.php and execNavigator.php took 15 to 17 seconds each.

[stef-lhm]

ok i found the solution.

$tlCfg->tree_filter_cfg->testcases->execution_mode->filter_assigned_user = DISABLED;

If i enable this, it takes much to long to build the drop down with all users. this causes 20 to 40 seconds delay in response time.