Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007320TestLinkTest Execute - Navigatorpublic2015-11-02 14:392015-11-19 16:33
ReporterBtTest 
Assigned To 
PriorityhighSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOSOS Version
Product Version1.9.14 (2015 Q3) 
Fixed in Version 
Summary0007320: SLow Execution tree construction
DescriptionHi,

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
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL / SQL server
Browser
PHP Version
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Fileszip file icon testlinkanonym.zip [^] (1,487,439 bytes) 2015-11-04 14:44

- Relationships

-  Notes
(0024189)
fman (administrator)
2015-11-02 16:58

only option is to have a dump of your db to do local tests
(0024190)
fman (administrator)
2015-11-02 17:07

if you want indications on 6390 you need to contact user not dev team
(0024191)
fman (administrator)
2015-11-02 17:16

>> 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
(0024193)
BtTest (reporter)
2015-11-03 15:17

Hi fman,

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
(0024195)
fman (administrator)
2015-11-03 15:32

Only way to try to help is having your db
(0024200)
BtTest (reporter)
2015-11-04 14:45

Hi,

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_name!='dual'
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 ?
(0024201)
fman (administrator)
2015-11-04 16:37

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
(0024272)
BtTest (reporter)
2015-11-19 16:33

Sorry for the delay ...

We learned this solution in differents posts on other forums.


Bye

- Issue History
Date Modified Username Field Change
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
Powered by Mantis Bugtracker