|Anonymous | Login | Signup for a new account||2019-06-19 17:51 UTC|
|Main | My View | View Issues | Change Log | My Account|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0007320||TestLink||Test Execute - Navigator||public||2015-11-02 14:39||2015-11-19 16:33|
|Product Version||1.9.14 (2015 Q3)|
|Fixed in Version|
|Summary||0007320: SLow Execution tree construction|
Currently, I use Testlink in the 1.9.9 version, and in this version, the execution tree construction is slow (about 1 min to refresh the tree).
I've seen that this sort of problem might be resolved in the 1.9.14 version (cf the report n°6390)
I've installed this version on a new serveur -> always the same slow execution tree construction.
I transferred the database to a SQL Server -> better but not enough
I ask you for new ideas.
I've seen the Jasmeet post in the report n°6390. I've not succeed in the installation of all his new files. Can he post me an explication of his méthod ?
Thanck for your help
|Tags||No tags attached.|
|Database (MySQL,Postgres,etc)||MySQL / SQL server|
|QA Team - Task Workflow Status||TBD|
|Attached Files||testlinkanonym.zip [^] (1,487,439 bytes) 2015-11-04 14:44|
|only option is to have a dump of your db to do local tests|
|if you want indications on 6390 you need to contact user not dev team|
>> Currently, I use Testlink in the 1.9.9 version, and in this version, the >>execution tree construction is slow (about 1 min to refresh the tree).
lot of info is missing, how many test projects, how many test plans, how many test cases, how many executions, etc
More informations of my problem:
- New installation
* 1 test project
* 26 000 test cases
* 10 seconds to open the test specification tree
* 1 test plan
* 170 test cases in the test plan (for my first test but the number of test cases in the test plan don't change the opening duration)
* 65 seconds to open the execute tests tree
Tks for your comments
|Only way to try to help is having your db|
We worked on our Testlink database and the opening duration the execution tree is now about 20 seconds !
What we done:
- make a backup of the database
- create a new empty database and restore the backup
Now, the opening falled down to 20s
We searched reasons of the difference between the two database and we discovered an possible optimization in the database tables with the OPTIMIZE sql command
1st command to have the optimization script:
SET SESSION group_concat_max_len = 99999999;
SELECT GROUP_CONCAT(concat('OPTIMIZE TABLE `', table_name, '`;') SEPARATOR '') AS O
FROM INFORMATION_SCHEMA.TABLES WHERE
TABLE_TYPE = 'BASE TABLE'
AND TABLE_SCHEMA = 'testlink'
2nd command, execute the answer of the first one:
OPTIMIZE TABLE `assignment_status`;OPTIMIZE TABLE `assignment_types`;......
I join my anonymized database to this post for performance testing.
Do you think that this performance can be even better ?
Great! I would like to know how you have designed this solution
>>Do you think that this performance can be even better ?
do not know
Sorry for the delay ...
We learned this solution in differents posts on other forums.
|2015-11-02 14:39||BtTest||New Issue|
|2015-11-02 16:57||fman||QA Team - Task Workflow Status||=> TBD|
|2015-11-02 16:57||fman||Summary||Low Execution tree construction => SLow Execution tree construction|
|2015-11-02 16:57||fman||Description Updated||View Revisions|
|2015-11-02 16:58||fman||Note Added: 0024189|
|2015-11-02 17:07||fman||Note Added: 0024190|
|2015-11-02 17:16||fman||Note Added: 0024191|
|2015-11-03 15:17||BtTest||Note Added: 0024193|
|2015-11-03 15:32||fman||Note Added: 0024195|
|2015-11-04 14:44||BtTest||File Added: testlinkanonym.zip|
|2015-11-04 14:45||BtTest||Note Added: 0024200|
|2015-11-04 16:37||fman||Note Added: 0024201|
|2015-11-19 16:33||BtTest||Note Added: 0024272|
|Copyright © 2000 - 2019 MantisBT Team|