Page 1 of 1

listcontent speed

Posted: Mon Jan 28, 2008 1:48 am
by baresi
I have spoken to Ted on IRC and he spoke of possible improvements in 2.0 and I searched various stuff here like increasing php memory, uninstalling modules, hierarchy...the first two I did and looks like the load is slightly better, hierarchy I should do but I noticed that listcontent was slow even above ~100 pages so collapsing won't help me that much because I need at least one parent open which will contain 100 or more pages anyhow.
But php and module stuff aside which help what I am looking for is to make my listcontent.php shorter, maybe adding pagination (looking at listcontent.php it existed at one point?), I have a few hundred pages now but the site will grow, so far in my tests the pages created (~10 queries) load ok, but its listcontent.php that seems to be the issue. I am willing to put this in the commercial help wanted forum but before I go too far I want to know if anybody has any ideas. Thanx

Re: listcontent speed

Posted: Mon Jan 28, 2008 6:10 am
by baresi
Site info :)
cmsms 1.2.3
linux,php 5.2.4,mysql 5.0.45

Re: listcontent speed

Posted: Tue Jan 29, 2008 4:10 pm
by Pierre M.
Hello,

you don't have problem with the public side ? Your problem is "only" about the admin side having difficulties to catch up with a large number of pages ?

Public side : try the cache module (ccontent & cstylesheet), try caching reverse proxy or mod_cache.
Admin side : hope 2.0 is going to better fit your needs.

Pierre M.

Re: listcontent speed

Posted: Tue Jan 29, 2008 5:35 pm
by baresi
Thanx for the reply. Yes, at least so far its only the admin side.
Looking forward to 2.0, hoping it is better in that way :)

Re: listcontent speed

Posted: Tue Jan 29, 2008 8:04 pm
by Ted
Just did some testing and tweaks to 2.0 this afternoon.  Using a test database with 33000 pages, I'm getting some nice speeds.  listcontent all collapsed is taking about 3 seconds to render.  The frontend (with menu collapsing on, but looking at a subpage 2 tiers deep) is taking about 0.2 seconds.

I'm still noticing a few potential fixes to listcontent, so it should get a bit faster before it's released.

Re: listcontent speed

Posted: Tue Jan 29, 2008 8:08 pm
by baresi
Sounds great, thanx very much Ted.