1.11.8 - Very slow editor [solved]

[lumimies]

Hi

I made upgrade to 1.11.8 few days ago and for my site it seems to made the backend much slower.

Anyone else have experienced this?

Slowing down occurs when page is opened for editing and the delay between opening click and editable page is about 60 seconds.

- Site has over 2000 pages, so it can be something in this - but this came with the upgrade to 1.11.8.

CMS 1.11.8
PHP 5.4.4
MySQL 5.5.25
Apache 2.2.22

[calguy1000]

I just tested CMSMS 1.11.8 with 3k pages (I have a UDT that will create a set amount of content pages).

I have PHP configured to 128mb of RAM.

I still cannot expand all content in the listcontent view.
However in editcontent, the page loads in ~3 seconds with 29 queries and 87MB of RAM.

I can confirm that this is considerably faster than in 1.11.7

[lumimies]

Hi

Ok - Thank You. I had a thought that maybe this has something to do with "db schema" -thing mentioned earlier. But obviously not then.

- Do You - or someone else have any idea what might cause delays so long? What might be the best way to troubleshoot the speed issue?

Or - should i go back to 1.11.7 to see if it solves this?

Thank You

[calguy1000]

Well...You have provided next to no information for anybody to be able to determine what the problem may be.

No system information
No list of modules
No indication of any special UDT's or plugins you are using
No indication of actual performance (some numbers would be useful).

There is little anybody can (or infact will) do to help if you don't provide information.

[lumimies]

Yep - point taken. Here is the system:

----------------------------------------------

Cms Version: 1.11.8

Installed Modules:

CMSMailer: 5.2.1
FileManager: 1.4.3
MenuManager: 1.8.6
ModuleManager: 1.5.5
News: 2.13
Printing: 1.1.2
Search: 1.7.10
ThemeManager: 1.1.8
TinyMCE: 2.9.12
CGExtensions: 1.37.2
CGFeedMaker: 1.0.17
FrontEndUsers: 1.21.18
FCKeditorX: 1.1.0
ExtendedTools: 1.3.3
CMSSimplepie: 1.0
Captcha: 0.4.6
Showtime: 3.3
CMSPrinting: 1.0.5
MicroTiny: 1.2.5
AdvancedContent: 0.9.4.3
CGSimpleSmarty: 1.7
JQueryTools: 1.2.5
MleCMS: 1.11.4
CGContentUtils: 1.3.6
RSSSimplePie: 1.0
PDFGenerator: 0.1
Archiver: 0.2.6


Config Information:

php_memory_limit:
process_whole_template:
max_upload_size: 20000000
url_rewriting: mod_rewrite
page_extension:
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale: fi_FI.UTF8
default_encoding: utf-8
admin_encoding: utf-8
set_names: true


Php Information:

phpversion: 5.4.4-14
md5_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 0
E_DEPRECATED: 0
memory_limit: 128M
max_execution_time: 120
output_buffering: 4096
safe_mode: Off (False)
file_uploads: On (True)
post_max_size: 20M
upload_max_filesize: 20M
session_save_path: /var/lib/php5 (1733)
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)


Server Information:

Server Api: apache2handler
Server Db Type: MySQL (mysql)
Server Db Version: 5.5.31
Server Db Grants: Found a "GRANT ALL" statement that appears to be suitable
Server Time Diff: No filesystem time difference found


----------------------------------------------

I do not have any numbers of the performance before update to 1.11.8 - only that system is now significantly slower than before update.

The problem seems to be only when opening page for editing. Everything else in backend and frontend seems to be fine.

- Of course is possible that this is a problem with my hosting for example. Slowing down just occured at time of update.

Thank You

[calguy1000]

Well... you have at least 4 areas that you would need to isolate

FCKEditor - This has not been maintained in years. I would be surprised if it still works.
if you aren't using it, uninstall it.
AdvancedContent
ExtendedTools
MleCMS

I suggest you do this:

A: Create a new template with just the basics in it. like: {content wywiwyg="false"}
B: Create a new "content" page using this new template (note: NOT advanced content).
This should take you less than 5 minutes. if that is reasonably fast, you could re-introduce the wysiwyg editor, and re-introduce the other elements to try to isolate the problem.

Any of the AdvancedContent, ExtendedTools or MleCMS modules could be doing some ugly things wrt content items to dramatically increase the time it takes (and probably the memory too) to load content pages.

[calguy1000]

Oh yeah, and I'd disable the archiver module for a while, and perform tests to see if that is the problem. It does some funky stuff with content pages etc at times.

You can disable it in Extensions >> Modules and shouldn't lose your history data.

[lumimies]

Hi

Ok - Thank You very much for these. I will do the steps that You suggested and try to isolate the problem.

- Archiver module is indeed potential suspect.

Best regards

[lumimies]

Hi

Just a little update for this:

- Deactivated Archive module - no significant change
- Made a new basic template with "wysiwyg_false" - and this really made the difference. Opening page for edit with no particular delay.

Then changed my wysiwyg-editor from TinyMCE -> MicroTiny

-> and the delay is also gone.

So - it seems that TinyMCE (ver 2.9.12) is the problem in my case. I reinstalled TinyMCE but that did not help.

I am trying to find what in TinyMCE causes this - or is it just part of the problem.

Thank You

[Rolf]

Yesterday Silmarilion was working on updating TinyMCE in the SVN. I don't know if the issues are related, but it might...

[lumimies]

Update

Just read Fred Polizos remarks from:

http://dev.cmsmadesimple.org/bug/view/9549

- So i also pulled class.contentoperations.php from SVN and installed it. That solved also my speed problem with TinyMCE.

Thank You!