listcontent speed

[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

[baresi]

Site info
cmsms 1.2.3
linux,php 5.2.4,mysql 5.0.45

[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.

[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

[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.

[baresi]

Sounds great, thanx very much Ted.