CMS Made Simple Forums

Hey all, we're in a tough spot with CMSMS.  Committed to making a CMSMS site for a client, and recommended a webhosting service that we've used for 6 years without incident.  It turns out that we have had major issues with CMSMS' speed.

Speed Issues

We built the CMSMS website (looks great) on my pc, then rolled out to the client's shared webhosting.  On the shared server, it crawls taking about 7-9 seconds to return any given page.  When it's run locally it's instantaneous.  We built a CMSMS portal a few months ago for client on a dedicated server that screams.  What are the factors that could cause CMSMS to crawl like this?  Is there any way to analyze or test what is causing the slowdown - some sort of debug tool or code?  I spoke to my webhosting provider, and they say they only have one machine w/multiple processors with Mysql for all clients (500-1000) using Mysql.  Is this maybe a problem with too many db connections being made to the MySql server?

Webhosting Problem - recommendations *please*

The slowness of the site is unacceptable to the client who paid for the site, so we may have to eat the cost of the original webhost, as we recommended them in the first place, and look for new hosting.  But before we commit/recommend a new webhost, we need to make sure that they can handle CMSMS so that the site has reasonable responsiveness (no than a second or two to return a page).  with this in mind:  1) What factors should I look for in picking hosting for CMSMS 2) Who do people recommend for CMSMS hosting?  I would like responses limited to people who have actually hosted with the companies they recommend, and the hosting services to be shared hosting.

Am i the only one with this problem...?

Thanks in advance,
Michael
michael@transmissionsllc.com

Hello,

when comparing "7-9 seconds" to "instantaneous", are you looking at the bottom in the source of the generated pages ? I mean something like "" ?

If you put too much gadgets in the same page (same template), it can take too much SQL queries to be rendered and slow down. (10 is OK, 20 is arround twice the load so half power).

500-1000 customers sharing a single MySQL engine ! Competitors can deliver better quality for 2¤ a month.

It seems you have a bad shared hosting provider. There are opinions in these forums about hosting providers. Search for the ones of your area.

Pierre M.

Hello Pierre,

Thanks for responding to my post. 

With your tip, I checked my pages.  Our pages, in general, consist of from 15-25 queries.  Pages with fewer queries take from 3/4 second to 1.5 seconds to generate, while pages with more queries take from 2.5 to 3 seconds to generate.  In absolute terms, from the time it Click a link, it takes from 5-10 seconds for a page to display.

Based on your comments, I would guess we putting a lot of stress on our portal - but why the disconnect between generation times and display times?  Do you think their webserver is overburdened as well?

Thanks,
Michael

There's an article on the blog section "Finding a suitable webhost" - something you may find interesting.
http://blog.cmsmadesimple.org/2007/01/2 ... n-part-12/
http://blog.cmsmadesimple.org/2007/01/2 ... n-part-22/

Hello Michael,
If there is an obvious correlation between the number of SQL queries and the rendering duration, you should try Cyberman's cache module : http://dev.cmsmadesimple.org/projects/cache/

Pierre M.

However, it's more appropriate for static content. The updated page won't load immediately - it depends on the time you set for the duration of caching.

Hey Michael

I've just found your post because the same is happening to me. We've developed about 20 cmsms sites in the past year, almost all of which are hosted on our VPS Webfusion box... which works really fast. We recently had a corporate client that required 4 sites - all built using the same version of cmsms. 3 sites work perfectly (and quickly) on our WebFusion, whilst the fourth insisted on using their existing server (easily.co.uk)...page load times are upwards of 5 secs on this server, whereas the sister sister sites all load in a second or so.

I've been in email dialog with the server tech guys, who've not been much help apart from suggesting that we move to a dedicated server with them (at much extra cost). They won't admit to having 1 MySql database for 100s of sites, but it seems that this may be the case.

Having said that the WebFusion VPS Server runs the sites well, the tech support leaves a lot to be desired since Pipex bought them, and now they seem to be selling to AOL, I can't recommend it.

Have you tried the cache module listed above? Did it work?
good luck,
rhys