Anonymous | Login | Signup for a new account | 2019-12-12 14:14 UTC | ![]() |
Main | My View | View Issues | Change Log | My Account |
View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||
0005810 | TestLink | Test Execute | public | 2013-07-15 03:26 | 2016-02-16 08:56 | ||||||||
Reporter | FelixLin | ||||||||||||
Assigned To | |||||||||||||
Priority | urgent | Severity | major | Reproducibility | always | ||||||||
Status | new | Resolution | open | ||||||||||
Platform | OS | OS Version | |||||||||||
Product Version | 1.9.7 (2013 Q2 - bug fixing) | ||||||||||||
Fixed in Version | |||||||||||||
Summary | 0005810: The left-tree-list view of TestExecution has poor performance | ||||||||||||
Description | The left-tree-list view of TestExecution has poor performance, more than 30 seconds to refreshed for 2 assigned cases in project with 4500 cases. | ||||||||||||
Steps To Reproduce | I tried a project with about 4500 test cases. In "TestSpecification" panel, the left-tree-list view has good performance(3 seconds to be refreshed). I set : $tlCfg->exec_cfg->user_filter_default='logged_user'; Only 2 cases were assigned to me. When I click on "TestExecution ", the left-tree-list view can only be drawn after 30 seconds. If I "save execution" for one case, the left-tree-list view can only be refreshed after 30 seconds. | ||||||||||||
Additional Information | TestLink 1.9.6 has no such problem. | ||||||||||||
Tags | No tags attached. | ||||||||||||
Database (MySQL,Postgres,etc) | MySQL | ||||||||||||
Browser | Firefox 22.0 | ||||||||||||
PHP Version | PHP Version 5.3.3 | ||||||||||||
TestCaseID | |||||||||||||
QA Team - Task Workflow Status | TBD | ||||||||||||
Attached Files | |||||||||||||
![]() |
|||||||||||
|
![]() |
|
(0019250) fman (administrator) 2013-07-15 09:35 |
Seem this has been explained on forum. Test Spec tree can be build using 'lazy mode' i.e. info is get only when user click on a folder. This is valid till you do not apply filters. When filters are applied, complete tree analisys is needed (see below Test Plan Tree). Test Plan tree has to be build COMPLETELY i.e. lazy can not be used. This explain why performance can not be the same. It will be interesting if you can provide same figures for 1.9.6, because do not think (may be I'm wrong) 1.9.7 has implementation on tree side. If you can provide your db or a similar one, will be great for me to plan some performance tests. |
(0019251) FelixLin (reporter) 2013-07-15 12:01 |
Thanks. I just got the performance from my colleague about 1.9.6. I will check the 1.9.6 comparing to 1.9.7. Then give out the result. |
(0019272) ansar (reporter) 2013-07-16 22:03 |
I have had the same problem for awhile. In our main test project, we have about 40,000 test cases. If I select "Execute Tests", "Add / Remove Test Cases", or "Assign Test Case Execution", it will take over 5 minutes for the left TreeView to be displayed. This has been the case for me in TestLink 1.9.3, 1.9.4, 1.9.5, and now 1.9.7. I will see if I can get our database randomized so as to give you a way to see what I am seeing. Or at least maybe generate a generic database that you can use to reproduce this issue. Thanks for your time. |
(0019273) fman (administrator) 2013-07-17 04:52 |
@ansar 1. having this kind of reports at the right time would be of help, i.e. if you find an issue report ASAP 2. ok if you can send me a db. as you can understand working on 40000 is not a thing that can be handle in a breeze. In addition who can analize a test execution report with 40000 test cases ? Only way to manage this is to forget to tree like view with the folder structure, and provide just test case with parent test suite, this way we remove time to rebuild the tree. To test if this will be a solution is to have 40000 test cases organized in N test suites but with ONLY one level deep, i,e. Test project TS1 ---> lets say this Test Suite contains 5000 test cases TS2 TS3 TS4 ... TS8 8 Test Suite with 5K test case each => 40K test cases will wait for your sample db |
(0019284) FelixLin (reporter) 2013-07-18 09:23 |
Hi? fman? ?tried the same DB with TestLink 1.9.6, it has the same performance problem. Do you mean, the less the test-suite level, the better performance it has? |
(0019288) fman (administrator) 2013-07-18 10:44 |
You have written: >> TestLink 1.9.6 has no such problem. then is not right OK ? >> Do you mean, the less the test-suite level, the better performance it has? IMHO yes, because amount of queries to build tree from leaf to root decrease |
(0019306) FelixLin (reporter) 2013-07-22 08:30 |
Yes, TestLink 1.9.6 has the same performance problem. |
(0019308) fman (administrator) 2013-07-22 10:20 |
Still waiting for a Sample DB |
(0019323) ansar (reporter) 2013-07-23 18:51 |
Ok, I got one of my guys to randomize all the data. The database is about 150 megs in size. Where is a good place to give it to you? |
(0019324) fman (administrator) 2013-07-23 19:50 |
before posting it please truncate transactions and events table. You can put it in a google drive ? an ftp site ? |
(0019326) ansar (reporter) 2013-07-24 16:40 |
Also, we obviously upped the various timeouts and memory usage limits in order to let the treeview complete. If you need those settings, let me know and I can get them. |
(0019327) fman (administrator) 2013-07-24 17:41 |
ok, provide me these settings, thanks |
(0019328) fman (administrator) 2013-07-24 18:15 |
just created db with sample file. I will try to provide some feedback during next weeks |
(0019329) ansar (reporter) 2013-07-24 22:11 |
Here are the settings we tweaked in php.ini. max_execution_time = 600 max_input_time = 600 memory_limit = 4096M |
(0020128) ansar (reporter) 2013-11-27 17:34 |
Any movement on this issue? I believe a related issue was also submitted: http://mantis.testlink.org/view.php?id=5751 [^] |
(0022081) fman (administrator) 2014-11-05 14:12 |
Unfortunately no |
![]() |
|||
Date Modified | Username | Field | Change |
2013-07-15 03:26 | FelixLin | New Issue | |
2013-07-15 09:35 | fman | Note Added: 0019250 | |
2013-07-15 12:01 | FelixLin | Note Added: 0019251 | |
2013-07-16 22:03 | ansar | Note Added: 0019272 | |
2013-07-17 04:52 | fman | Note Added: 0019273 | |
2013-07-18 08:39 | fman | Relationship added | has duplicate 0005816 |
2013-07-18 09:23 | FelixLin | Note Added: 0019284 | |
2013-07-18 10:44 | fman | Note Added: 0019288 | |
2013-07-18 13:44 | fman | Relationship added | related to 0005819 |
2013-07-22 08:30 | FelixLin | Note Added: 0019306 | |
2013-07-22 10:20 | fman | Note Added: 0019308 | |
2013-07-23 18:51 | ansar | Note Added: 0019323 | |
2013-07-23 19:50 | fman | Note Added: 0019324 | |
2013-07-24 16:40 | ansar | Note Added: 0019326 | |
2013-07-24 17:41 | fman | Note Added: 0019327 | |
2013-07-24 18:15 | fman | Note Added: 0019328 | |
2013-07-24 22:11 | ansar | Note Added: 0019329 | |
2013-11-27 17:34 | ansar | Note Added: 0020128 | |
2014-11-05 14:12 | fman | Note Added: 0022081 |
Copyright © 2000 - 2019 MantisBT Team |