Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008663TestLinkTest Specificationpublic2019-05-16 08:092019-05-20 13:02
Reporterstef-lhm 
Assigned Tofman 
PriorityhighSeveritymajorReproducibilityalways
StatusassignedResolutionopen 
PlatformOSOS Version
Product Version1.9.19 (2019 Q1) 
Fixed in Version 
Summary0008663: Create new test case version takes 60 seconds
DescriptionI try to create a new test case version from an exsiting testcase.
if you press the button, it take 60 seconds until i get a response.
I donĀ“t know what happens there. This SQL Statemant causes such a long delay.

Class:testcase - Method: closeOpenReqVersionOnOpenLinks */ UPDATE
req_versions
              SET is_open = 0
              WHERE id IN (
                  SELECT req_version_id
                  FROM req_coverage
                   WHERE tcversion_id = 471645 AND link_status = 1
              ) AND is_open = 1
Additional Informationas you can see, we have a lot of testcases and 2500 users.
all the other responses work fine, but creating a new version is a problem.
TagsNo tags attached.
Database (MySQL,Postgres,etc)mysql
BrowserFF60 or higher
PHP Version5.6.25
TestCaseID
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
(0028828)
fman (administrator)
2019-05-16 14:27
edited on: 2019-05-16 14:31

Thanks I'm going to understand if performance of this piece can be improved

would you mind to add an index on tcversion_id column and retest?
I don't have a Database big enough to do a serious test.

(0028840)
stef-lhm (reporter)
2019-05-20 06:47

thanks for your reaction.
an index on tcversion_id was our first try, too. No change on performance.
Btw. with user more than 2000, the performance of some sites is down. For example in Testeexecution i had to disable the user drop down in filters. If not, you wait 40 to 60 seconds for each result.
(0028841)
fman (administrator)
2019-05-20 07:12

Any chance that you will send me a copy of your db?
(0028842)
stef-lhm (reporter)
2019-05-20 10:58

I wish i could, but then i can look directly for a new job ;))
(0028843)
stef-lhm (reporter)
2019-05-20 10:58

Can you generate Users and testcases with a small script?
(0028844)
fman (administrator)
2019-05-20 12:17

It's not easy generate the testcases with n tree structure that can reproduce your use case.
Creating users is not an issue
(0028845)
stef-lhm (reporter)
2019-05-20 12:50

maybe it is enough just to create users.
(0028846)
stef-lhm (reporter)
2019-05-20 13:02

But export/import will help you to create many Testcases quick and easy

- Issue History
Date Modified Username Field Change
2019-05-16 08:09 stef-lhm New Issue
2019-05-16 14:27 fman Note Added: 0028828
2019-05-16 14:31 fman Note Edited: 0028828 View Revisions
2019-05-16 14:31 fman Note Edited: 0028828 View Revisions
2019-05-16 14:31 fman Assigned To => fman
2019-05-16 14:31 fman Status new => feedback
2019-05-20 06:47 stef-lhm Note Added: 0028840
2019-05-20 06:47 stef-lhm Status feedback => assigned
2019-05-20 07:12 fman Note Added: 0028841
2019-05-20 10:58 stef-lhm Note Added: 0028842
2019-05-20 10:58 stef-lhm Note Added: 0028843
2019-05-20 12:17 fman Note Added: 0028844
2019-05-20 12:50 stef-lhm Note Added: 0028845
2019-05-20 13:02 stef-lhm Note Added: 0028846



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker