View Issue Details

IDProjectCategoryView StatusLast Update
0007463mantisbtbugtrackerpublic2008-04-19 04:10
Reporterralfiii Assigned Tograngeway  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
PlatformWinOSWin2KServer 
Product Version1.0.5 
Fixed in Version1.2.0a1 
Summary0007463: Issue with many child issues produced performance problem
Description

We have an issue with ~200 child issues (next major release of a software).
When I want to view this issue, even on a very fast machine the processor is used 100% for >5 secs.
(On our server, which is old and slow this feels like ages)

Also if a open an issue and set "child of" to this big parent, it takes the same (very long) time before anything happens.

TagsNo tags attached.

Activities

striker69

striker69

2006-11-24 09:41

reporter   ~0013752

I do have the exact same issue. The problem resides in the methods <b>relationship_get_all_dest</b> and <b>relationship_get_all_src</b>

It is either the select in the DB (MySQL in my case) or the scanning of the results.

Ideas?

vboctor

vboctor

2006-12-22 04:36

manager   ~0013860

We probably need to tune the queries. But in the future you should consider using the roadmap feature that will be available in Mantis 1.1. It's already included in 1.1.0a2.

http://www.mantisbt.org/wiki/doku.php/mantisbt:features:roadmap

grangeway

grangeway

2007-11-11 08:07

reporter   ~0016151

Hello,

The following two patch sets should fix or at least improve this issue:

http://mantisbt.svn.sourceforge.net/viewvc/mantisbt?view=rev&amp;revision=4744
http://mantisbt.svn.sourceforge.net/viewvc/mantisbt?view=rev&amp;revision=4741

Paul