[solved] admin - very slow

[jeepin81]

Hello,

when we go to edit pages the Admin is loading extremely slow. 51+ seconds to load the edit page and to save it back it takes about 20-30+sec's. Even just browsing around the admin side take awhile... 10-15secs..

Here are the specs:
- CMSMS version 1.11.7
- PHP 5.3.13
- Virtual Windows Server 2008
- WAMP Stack
- 4GB MEM

Front side of the site is fine... pages load quick. Only having the issue with Admin.

Any thoughts?

Thanks in advance..
J

[Rolf]

Do you use a sitemap module, like SiteMapMadeSimple?

[jeepin81]

no, we do not.

[jeepin81]

Another note:

I just installed a fresh version CMSMS on the same server just to check the speed and it works great.

Couple of thoughts:

- too much data?
we maintain daily news and have about 3-1/2 years worth up there. plus, lots of other data.

- module conflict(s)?

Here's a list of modules we use:
FileManager 1.4.3
MenuManager 1.8.5
ModuleManager 1.5.5
News 2.12.12
Printing 1.1.2
Search 1.7.8
ThemeManager 1.1.8
TinyMCE 2.9.12
CGExtensions 1.35
CustomContent 1.9
AjaxMadeSimple 0.1.6
CGExtensions 1.35
FrontEndUsers 1.21.16
CGCalendar 1.10.4
Gallery 1.6.1
SuggestBox 1.0
GroupShare 1.0
CMSPrinting 1.0.4
MicroTiny 1.2.5

We don't really have many images on our site - mostly text. We use CMSMS as our company intranet.. so the bulk is the Daily News we maintain and then we have a few hundred pages of procedures and some calendar events.

Another thing, it was decent with speed until we upgraded from 1.9.4.

Thanks again for any insight...

[Rolf]

What are these?

SuggestBox 1.0
GroupShare 1.0

[jeepin81]

Hey Rolf....

those are a couple modules we wrote for internal use. Basic modules built off the skeleton module.

[calguy1000]

a: Disable (not uninstall) one module at a time till you see where the issue is.
b: enable 'show_performance_info' it will tell you the amount of ram and number of database queries you are using. if either is stupidly high (say above 32mb) when editing a page then that'd be your problem.
c: we didn't write the system information page for nothing.
d: debug mode is very useful in this case to find where your bottelnenecks are.
it displays a time, and memory at numerous places in the page buiild process.

if you can develop modules, you can debug issues like this.

[jeepin81]

pardon my naiveness when looking at the CMSMS debug... but what am I looking at?

With debug enabled and I go to the admin and click on a page to edit and wait the 51+ seconds I see long list of "debug" info but I don't exactly understand what this info is showing me. Here are few lines of debug from the admin:

Code: Select all

Debug: (2.6999999999999E-5) - (usage: 2147792) - (peak: 2256352) done loading required files
Debug: (0.00074200000000002) - (usage: 2156280) - (peak: 2256352) loading adodb
Debug: (0.002048) - (usage: 2324520) - (peak: 2397120) loading page functions
Debug: (0.003603) - (usage: 2598512) - (peak: 2713816) loading content functions
.
.
.
.
.
Debug: (2.270478) - (usage: 70775840) - (peak: 71010744) after populate admin navigation

What does the first number represent? What is the difference between the usage & peak?

With "show_perfomance_info" I only see info on the front-side of the site and I have the same ??'s there:

Code: Select all

Debug: (5.813098) - (usage: 38642032) - (peak: 39249112)
5.81296 / 145 / 37795040 / 39249112

Again, I apologize for being green here but I'm just trying to work through this issue we have.

Our next step is to take your advice and start stepping through and disabling modules to see if something jumps out there.

Thanks for the insight...
j

[calguy1000]

Code: Select all

Debug: (2.270478) - (usage: 70775840) - (peak: 71010744) after populate admin navigation

2.27 seconds... memory usage at that time was 70775840 bytes... peak memory usage 71010744 bytes.

2.27 seconds and ~70mb is extreme. doesn't happen on a stock install.

[jeepin81]

It does appear we are seeing that across the board....

That being said if we disable TinyMCE the edit page loads in out 6-8sec's - which I would say is a huge improvement.

But, with that disabled and in debug mode we're still seeing those high thresholds. Here is that same line from debug with TinyMCE disabled.

Code: Select all

Debug: (2.209688) - (usage: 71107072) - (peak: 71352720) after populate admin navigation

any thoughts?

I appreciate the help.

[Dr.CSS]

tinyMCE has a setting where it doesn't start on page edit, you tick the turn wysiwyg off/on to see it...

[jeepin81]

Dr.Css... thanks for the reply.

Same result with that option. It appears wysiwyg just load in a hidden div so it's still taking 50+ seconds to load that content.

Is anyone aware of another wysiwyg editor/module or some other setting that might be causing this issue?

I only saw the TinyMCE but I could have missed one.

Thanks for the insight..

[jeepin81]

A quick update of things I've tried:

0.) Reset all tinyMCE settings back to default - no change

1.) Uninstalled & reinstalled tinyMCE - no change

2.) Disabled the wysiwyg from user preferences and that fixed the speed issue but of course removed the wysiwyg.

3.) Set the microTinyMCE as the user wysiwyg - helped with speed a little bit but was still about a 30+ sec load time.

4.) Installed Dojo Editor but that module was pretty much useless.

5.) On my fresh CMSMS install. I installed tinyMCE to see if that replicated the issue on that install - it did not. Everything was moving fast.

6.) Went through and disabled/enabled all installed modules and tinyMCE was the only culprit.


I would say to h3ll w/ the tinyMCE but our intranet editors are not HTML savvy.

As always... I appreciate any other insight or ideas or thoughts.

Thanks,
j

[calguy1000]

by the debug report the PHP was only taking ~2 seconds and 70mb to load
that's way too long.

How many WYSIWYG enabled text areas are in your template? why is it taking 2 seconds to load a page? my website has a template with 3 or 4 content blocks and a whole crapload of modules installed. Editing a page takes ~0.5 seconds and 16mb of RAM.

[jeepin81]

Calguy.. thanks for the reply.

We have two wysiwyg text areas in our template. One is a restricted area. We use FEU module and have content only Admins can see in there.

The template we use / other usage info:

- Top simple navigation + left subnavigation + 1 column

- We have 12 active categories and 100's of pages

- About 40 users at one time throughout the day.


It's taking much longer then 2 seconds to load the edit page... it's taking upwards of 50+ seconds but only when the tinyMCE is enabled. with it disabled we're seeing the edit page load in about 6-8secs.

Don't really know what else to look at.

If more data from debug would help or if anything else would help, I'd be happy to post.

Thanks for all the help.
j