Admin Page Timing Out

Thursday 06 April 2006 1:11:56 am

Hello,

We have ez 3.7.2 on a P4 2G RAM, when trying to access the admin interface the connection times out, apache's memory usage jumps to 900MB for the child that was handling the request.

After some investigation we think the problem is related to the treemenu in the left part of the admin interface, we have a node 'News' which has 200,000 objects directly under it, building the treemenu to handle this amount of objects results in the timeouts and the huge memory usage (Even the Ajax TreeMenu plugin times out).

How can we disable 'generating and pushing' the treemenu from the controller to the view, if I remove the treemenu code from the template that wouldn't stop the controller from pushing this content anyway, right?

Sorry if I'm totally off track but I am not a developer.

Here is a link to a call trace with full parameters (250MB, 23MB gzipped)

http://205.234.207.181/trace.2043925204-2.xt.gz

To be honest I couldn't make out anything useful out of it, here are my notes anyway:

1) At line 278863 is a slow sql query that took about 16 seconds.
2) At line 281520 is another slow query.
3) From line 281552 to line 490016 are mysql_fetch_array() calls which seem to be related to node 64

Thursday 06 April 2006 2:41:11 am

I changed the contentstructuremenu.ini to the following

ShowClasses[]=forums
RootNodeID=2
MaxDepth=3

I also tried those in an override file, now the login pages times out too.

Thursday 06 April 2006 6:08:21 am

yes and yes :)

Thursday 06 April 2006 6:39:03 am

<b>Settings for contentstructuremenu.ini in siteaccess albawaba_admin</b>

ShowClasses      default       [0] forums
                          override     [1] forums

Sunday 09 April 2006 12:04:31 am

I checked the database and everything seems to be fine, sure it took like 4 hours to check considering that the database is at 17G right now.