Performance Improvement in 1.9.4

[amkhullar]

Hi All,

Just putting up some performance stats after testing the 1.9.4 release against the existing 1.9.3 release.

DB Cardinality:
Total Row Counts in tables
Test Project:7
Test Plan:34
Test Cases:55531
Executions:49521

*******************************
For a specific Test Plan with around 16000 Assigned Test Cases:
Test Spec Screen: Fast ( <4sec)
Test Case Assignment screen: Left pane tree was consuming lots of memory/time in 1.9.3:
* 1.9.3: Display took 140 sec
* 1.9.4: Display took 8 sec

This has been a huge performance improvement in 1.9.4 code base.

Will post numbers when I test the reports.

Amit Khullar

[breizou]

Hello,

I'm new here on the forum. I used TL 1.9.3 in my previous company and today I'd like to deploy it in my current company as it's a good tool. I have installed TL 1.9.4 with windows 7 64 bits using IE 9.0 to perform some tests mainly performance tests.
We develop several products which are quite the same for most of all except some customisation stuffs, so I'd like to reuse tests suite by export/import xml and thus add/remove/modifiy some existing tests case.
Here are the parameters I've modified to have what I want:

Parameters in file "config.inc.php":
$tlCfg->import_file_max_size_bytes = '20480000';
$tlCfg->repository_max_filesize = 256; //MB
$tlCfg->config_check_warning_mode = 'SILENT';

Parameters in file php.ini:
max_execution_time = 60000
upload_max_filesize = 256M
session.cache_expire = 90000
memory_limit = 1024M
post_max_size = 100M

First I have exported an existing test specification of 22590 tests, it took around 2/3 minutes: OK then
I have imported the xml generated (about 14 M) in a new project: it took about 13 min: NOK then I removed all it took 2/3 min: OK.
It means it takes nearly 30 seconds for each test case when trying to import tests cases from a xml file
I have noted the memory used by Apache begins at 99 M then increases, increases... until nearly 1G! Is it normal?
May I configure something else or someone has the same behavior than me?
Thanks for your feedback!

David

[fman]

We do not have created XML export/import with the aim of backup, or to do this kind of bulk import.
>> It means it takes nearly 30 seconds for each test case when trying to import tests cases from a xml file
this is not really true, this happens because you are importing a really BIG FILE (14M) with 20K testcase.
Again IMHO this is an extreme situation, and will be very difficult or us allocate resources to try to fix this.
I'm sorry.

[breizou]

Hi,

Okay... Does it mean it could be an improvement for next realease of TL?
David

[fman]

not sure, because as I've stated is a very extreme situation that we do not consider a situation that happens normaly.
Please provide in someway the moster file in order to allow us to try to so in future some tests.

[breizou]

Hereafter the file.xml I used.
http://www.uploadlux.com/l-5090cad7e1990

David

[vishal bharti]

I am currently using Testlink1.9.3 for Test Management and execution of our project from last 5 years. First we started with testlink1.6.3 version now i have migrated to 1.9.3. Now iam getting performance issue while clicking Test execution link. Tree will take time to load.

Detailed Information :

The test link performance is quite slow.

It is taking time to load the test project It is taking time to load the test plan While executing the test cases the performance is Fair While creating new plan/build the performance is Fair

Machine Detials:

Database size is :- 193 MB

Database server detail Processor :- Intel Xeon CPU X3470 @ 2.93GHz RAM :- 15GB

Application's H/W machine detail is as below Processor :- Intel Core i3 CPU @ 2.93GHz
RAM :- 4GB

Configurations at the application level are set to have get best performance like making sure below parameters are set:

$g_use_ext_js_library = ENABLED;

$tlCfg->treemenu_type = 'EXTJS';

And double checked to see if there can be any other configuration improvements that can be made.

Logs: Use of undefined constant TL_LIGHTBOX_CSS - assumed 'TL_LIGHTBOX_CSS' - in /var/www/html/thunder/gui/templates_c/%%56^560^56038526%%inc_head.tpl.php - Line 40 [<<][512c073808f8a063878788][DEFAULT][/lib/execute/execNavigator.php][13/Feb/26 00:52:08][13/Feb/26 00:52:25][took 17.290396 secs]

I have also migrated 1.9.3 to 1.9.5 but performance issue is still there. Please suggest can i need to change the code or db query which will increase the performance

Any help on this would be highly appreciated. Still waiting the expert answer.

[fman]

>> Still waiting the expert answer.
what does this means ?

only option upgrade to 1.9.5

[vishal bharti]

Hi fman my meaning is : can any behavior or code where i am able to increase the efficiency. I have already upgraded to 1.9.5 but issue is still there.

Any suggestion in code change ?

Thanks in advance and your reply.

[fman]

Sorry I've read in quick mode, but any way IMHO important info was not highlited well.

>> The test link performance is quite slow.
means absolutely nothing
Suggestions to code change are obvioulsy impossinble, because If we know what to do we normally do it
This can not be followed on forum, then open an issue on mantis what with detailed info about testlink items qty because
the tree suffer for this. We need same kind of info provided in first post by AmitKhular.
HW info is not important ( we can not provide any advice on this)

I can provide (on donation basis) performance analisi on you DB if you provide me an export.
(contat me at francisco.mancardi@gmail.com)

[vishal bharti]

Hi fman,

Thanks for your reply.
Sorry, i dont have permission to share the DB.

I just guess one solution if you can help me. Like when tree loaded on execution time it will also displayed counters of no of pass/fail/total test cases.
So this is the one reason where tree takes time to load because when i hit "Requirement Specification" link then tree takes just 3-4 sec to show all the cases.

If you can guide me how to edit the query/code where i remove the counters on execution time. I have already done using config file to hide the counters but unable to find the solution.

Thanks in advance