[Solved]Content manager is very slow

[archeo]

hello,

There are actually 312 pages in my website data bank. With version 1 using "Expand All Sections" in current pages spends 5 seconds but in version 2.0 it spends 10 s with Content manager.

OS : Windows 7
Wamp 2.5


? Modules not in Module Manager listing and not in modules directory


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

Cms Version: 2.0

Installed Modules:

CMSMailer: 5.2.4
FileManager: 1.5
ModuleManager: 2.0
News: 2.50
Printing: 1.0.4
Search: 1.50
ThemeManager: 1.1.8
?TinyMCE: 2.9.12
AdminSearch: 1.0
?Slide: 1.0
Showtime: 3.4
AceEditor: 1.0
?Statistics: 1.1.3
CGExtensions: 1.48.2.1
MicroTiny: 2.0
Gallery: 2.0.2
?HitCounter: 1.1
CGFeedMaker: 1.0.20
?NewsSlides: 1.4
UsersGuide: 1.8.1
?CodeMirror: 3.0.0
AjaxMadeSimple: 0.4.0
DownCnt: 2.5.0
SiteMapMadeSimple: 1.2.8
ModuleXtender: 1.10.6
DocumentSearch: 1.4.5
?Quizzard: 0.9
CGSmartImage: 1.19.1
?Polls: 1.1.0
CMSContentManager: 1.0
DesignManager: 1.0
Navigator: 1.0
CGSimpleSmarty: 2.0


Config Information:

php_memory_limit:
max_upload_size: 64000000
url_rewriting: mod_rewrite
page_extension: .html
query_var: page
auto_alias_content: true
locale:
set_names: true
timezone: Europe/Paris
permissive_smarty: false


Php Information:

phpversion: 5.5.12
md5_function: On (True)
json_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 0
E_DEPRECATED: 0
test_file_timedifference:
test_db_timedifference:
memory_limit: 256M
max_execution_time: 120
output_buffering: 4096
file_uploads: On (True)
post_max_size: 10M
upload_max_filesize: 64M
session_save_path: c:/wamp/tmp (0777)
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)


Performance Information:

allow_browser_cache: On (True)
browser_cache_expiry: 6000
php_opcache: Off (False)
smarty_cache: Off (False)
smarty_compilecheck: Off (False)
smarty_cache_udt: Off (False)
auto_clear_cache_age: On (True)

Server Information:

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


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

[calguy1000]

I just tested this on my server
(note my web server is an ubuntu 13.04 virtual machine that is running on my desktop machine).
My desktop machine is ubuntu 14.04.

- I created ~450 content pages (using advanced copy from CGContentUtils)
- I re-organized all of those 450 pages into various parent/child relationships (re-order content works nice for this).
- I tested expand/collapse all pages.

On my setup, with my pagelimit set to 500 items... it took ~5 seconds to expand all and then redraw.

I then looked at the code. The code itself is relatively well optimized and does not get extremely expensive until the page limit is huge. due to the fact that each and every page must be loaded. More pages == slower. That is why we added pagination. There are also more features in the content manager of 2.0... so rendering is a bit slower than before.

That said... I did find a few very minor optimizations that I will commit for 2.0.1 but they did not significantly impact the perceived performance.

To optimize the perceived performance, I suggest you set the filter page limit to about 100 then it will display (and load) a maximum of 100 rows.

[calguy1000]

I would also check out your windows server to make sure that you do not have name resolution issues with things like 'localhost' (try using 127.0.0.1 in the db_hostname parameter of your config.php)

[archeo]

Thank you very much for all those informations. I tested version 2.0.1, here there is some time (~ 10 s) when part of the page under "Content Manager" remains white. This is very confusing and gives thinking that nothing works.
For ergonomic raisons I would recommend an automatic switching to "page limit" = 50 or 100 when pages number is greater than 50 or 100.
Below is a part of the apache log (firefox no cache to see all the steps)

Code: Select all

127.0.0.1 - - [17/Sep/2015:16:53:20 +0200] "GET /test-mise-a-jour2/admin/moduleinterface.php?mact=CMSContentManager,m1_,defaultadmin,0&_sk_=06c100c95779daaf&m1_expandall=1 HTTP/1.1" 200 48142
127.0.0.1 - - [17/Sep/2015:16:53:22 +0200] "GET /test-mise-a-jour2/lib/jquery/js/jquery-ui-1.10.4.custom.min.js HTTP/1.1" 200 228539
127.0.0.1 - - [17/Sep/2015:16:53:22 +0200] "GET /test-mise-a-jour2/lib/jquery/js/jquery.mjs.nestedSortable.js HTTP/1.1" 200 13982
127.0.0.1 - - [17/Sep/2015:16:53:22 +0200] "GET /test-mise-a-jour2/lib/jquery/js/jquery-1.11.1.min.js HTTP/1.1" 200 95786
.
.
.
127.0.0.1 - - [17/Sep/2015:16:53:23 +0200] "GET /test-mise-a-jour2/admin/themes/OneEleven/css/default-cmsms/images/ui-bg_highlight-soft_75_cecece_1x100.png HTTP/1.1" 200 280
127.0.0.1 - - [17/Sep/2015:16:53:23 +0200] "GET /test-mise-a-jour2/admin/moduleinterface.php?mact=CMSContentManager,m1_,ajax_get_content,0&_sk_=06c100c95779daaf HTTP/1.1" 200 1665474

               >>>>10 seconds : part of the page under "Content Manager" remains white<<<<

127.0.0.1 - - [17/Sep/2015:16:53:33 +0200] "GET /test-mise-a-jour2/admin/themes/OneEleven/images/icons/system/newobject.gif HTTP/1.1" 200 362
127.0.0.1 - - [17/Sep/2015:16:53:33 +0200] "GET /test-mise-a-jour2/admin/themes/OneEleven/images/icons/system/run.gif HTTP/1.1" 200 394
.
.
.
127.0.0.1 - - [17/Sep/2015:16:53:33 +0200] "GET /test-mise-a-jour2/admin/themes/OneEleven/images/icons/system/copy.gif HTTP/1.1" 200 256
127.0.0.1 - - [17/Sep/2015:16:53:33 +0200] "GET /test-mise-a-jour2/admin/themes/OneEleven/images/icons/system/delete.gif HTTP/1.1" 200 385
127.0.0.1 - - [17/Sep/2015:16:53:36 +0200] "GET /test-mise-a-jour2/admin/themes/OneEleven/css/default-cmsms/images/ui-bg_flat_75_ffffff_40x100.png HTTP/1.1" 200 208