Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0002610TestLinkDatabase MySQLpublic2009-06-13 03:142010-05-01 20:35
Reporterschlundus 
Assigned Toschlundus 
PrioritynormalSeveritycrashReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version1.8.3 
Fixed in Version1.9 Beta 2 
Summary0002610: Performance issue in Report "Test Cases not assigned to Any Test Plan" due to inperformant SQL query
Descriptioncause: SQL query in testproject::getTCasesLinkedToAnyTPlan)( is inperformant
see statistics


1, 'PRIMARY', 'nodes_hierarchy', 'ALL', '', '', '', '', 20137, 'Using where; Using temporary; Using filesort'
2, 'DEPENDENT SUBQUERY', 'testplan_tcversions', 'index', '', 'tp_tcversion', '8', '', 3328, 'Using where; Using index'
3, 'DEPENDENT SUBQUERY', 'NH', 'eq_ref', 'PRIMARY,pid_m_nodeorder', 'PRIMARY', '4', 'func', 1, 'Using where'
3, 'DEPENDENT SUBQUERY', 'NT', 'eq_ref', 'PRIMARY', 'PRIMARY', '4', 'testlinktest.NH.node_type_id', 1, 'Using where'
TagsNo tags attached.
Database (MySQL,Postgres,etc)
Browser
PHP Version
TestCaseID
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2009-06-13 03:14 schlundus New Issue
2009-06-13 03:14 schlundus Status new => assigned
2009-06-13 03:14 schlundus Assigned To => schlundus
2009-06-13 03:15 schlundus Status assigned => resolved
2009-06-13 03:15 schlundus Fixed in Version => 1.9 (DEV)
2009-06-13 03:15 schlundus Resolution open => fixed
2009-06-13 03:15 schlundus Product Version => 1.8.3
2010-05-01 20:35 fman Status resolved => closed



Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker