View Issue Details

WikiRelated ChangesetsJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0010963mantisbtdb mysqlpublic2009-09-18 07:102009-10-07 14:19
ReporterRaul Assigned Tojreese  
PrioritylowSeveritytweakReproducibilityalways
Status closedResolutionfixed 
Product Version1.1.8 
Target Version1.2.0rc2Fixed in Version1.2.0rc2 
Summary0010963: slow query to table called "mantis_project_hierarchy_table"
Description

We are working with 270 projects (with a lot of subprojects) in DB, when we access to "Manage projects" the page is loaded in 32 seconds, it´s a lot of time.

We have fixed this problem, we have created a INDEX for table "mantis_project_hierarchy_table" with field "child_id".

Now page is loaded en 1.9 seconds.

TagsNo tags attached.

Relationships

has duplicate 0011390 closeddhx Manage Project page is slow 

Activities

dhx

dhx

2009-09-18 07:50

reporter   ~0022965

Is 270 projects a typo? I've never heard of MantisBT scaling to sites that large... all I can say is WOW!

I've targeted this for fixing in 1.2.x.

Thanks for reporting this bug :)
Wepl

Wepl

2009-09-29 13:11

reporter   ~0023045

I have 942 projects, but with less bugs per project (http://mantis.whdload.de/)
jreese

jreese

2009-10-06 15:49

reporter   ~0023086

Fix committed to 1.2 and master branches. Requires running /mantisbt/admin/install.php to update the database schema with the new index definitions.

Related Changesets

MantisBT: master-1.2.x 7e2a0100

2009-10-06 09:52

jreese


Details Diff		 Fix 0010963: Add indexes to project hierarchy table Affected Issues
0010963
mod - admin/schema.php Diff File

MantisBT: master 520c3e77

2009-10-06 09:52

jreese


Details Diff		 Fix 0010963: Add indexes to project hierarchy table Affected Issues
0010963
mod - admin/schema.php Diff File