0007463: Issue with many child issues produced performance problem - MantisBT

MantisBT

View Issue Details [ Jump to Notes ] [ Wiki ]

[ Issue History ] [ Print ]

ID

Project

Category

View Status

Date Submitted

Last Update

0007463

mantisbt

bugtracker

public

2006-09-22 05:04

2008-04-19 04:10

Reporter

ralfiii

Assigned To

grangeway

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

Win

OS

Win2KServer

OS Version

Product Version

1.0.5

Target Version

Fixed in Version

1.2.0a1

Summary

0007463: 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.

Tags

No tags attached.

Relationships

Notes
(0013752) striker69 (reporter) 2006-11-24 09:41	I do have the exact same issue. The problem resides in the methods relationship_get_all_dest and relationship_get_all_src It is either the select in the DB (MySQL in my case) or the scanning of the results. Ideas?

(0013860) vboctor (administrator) 2006-12-22 04:36	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 [^]

(0016151) grangeway (developer) 2007-11-11 08:07	Hello, The following two patch sets should fix or at least improve this issue: http://mantisbt.svn.sourceforge.net/viewvc/mantisbt?view=rev&revision=4744 [^] http://mantisbt.svn.sourceforge.net/viewvc/mantisbt?view=rev&revision=4741 [^] Paul

Issue History
Date Modified	Username	Field	Change
2006-09-22 05:04	ralfiii	New Issue
2006-11-24 09:41	striker69	Note Added: 0013752
2006-12-22 04:36	vboctor	Note Added: 0013860
2007-11-11 08:07	grangeway	Status	new => resolved
2007-11-11 08:07	grangeway	Resolution	open => fixed
2007-11-11 08:07	grangeway	Assigned To	=> grangeway
2007-11-11 08:07	grangeway	Note Added: 0016151
2007-11-11 08:07	grangeway	Fixed in Version	=> 1.2.0
2008-04-19 04:10	vboctor	Status	resolved => closed

MantisBT 1.2.16dev master-1.2.x-8c2bd07 [^]

Copyright © 2000 - 2013 MantisBT Team

Time: 0.0948 seconds.
memory usage: 2,781 KB