0011390: Manage Project page is slow

ID	Project	Category	View Status	Date Submitted	Last Update
0011390	mantisbt	performance	public	2010-01-13 09:20	2010-04-23 23:23

Reporter	gordon1986	Assigned To	dhx
Priority	high	Severity	minor	Reproducibility	always
Status	closed	Resolution	duplicate
Product Version	1.1.8

Summary	0011390: Manage Project page is slow
Description	We have 530 projects which are all a subproject of a single container project. Attempting to open the Manage Projects page as any user results in a five minute loading time. I had to increase the PHP memory limit to 256MB and the maximum execution time for scripts to 6 minutes to even get the page to load.
Steps To Reproduce	Set up a blank Mantis 1.1.8 installation, import > 500 projects into the database, assign them all to be a subproject of a single one.
Additional Information	Relevant MySQL tables are mantis_project_hierarchy_table mantis_project_table
Tags	No tags attached.

gordon1986 2010-01-13 09:21 reporter ~0024139	The exact page filename is manage_proj_page.php

dhx 2010-01-13 09:36 reporter ~0024140	This has been fixed in the upcoming 1.2.x release. You can grab the latest 1.2.0RC2 to confirm the performance fix if you'd like :) Thanks David