CMS Made Simple Forums

Posted: **Tue Sep 12, 2006 8:04 pm**

Since I installed CMSMadeSimple on my server, my website is very slow.

What can I do about it?

Posted: **Fri Sep 15, 2006 9:35 am**

Which CMSms version?

Posted: **Fri Sep 15, 2006 1:43 pm**

I just visited here to mention the same thing. My server load flies up as soon as you save anything. It's my own dedicated server, so I know that it's CMSMS causing the issue. I'm using 1.0.1.

Posted: **Fri Sep 15, 2006 4:11 pm**

php version?
mysql version?
linux/windows
apache?

Posted: **Fri Sep 15, 2006 5:22 pm**

PHP 4.3.10
MySQL 4.0.27
Linux/Apache

I just installed 0.13 and I'm using it just fine, no massive server loads. I also have another site running 1.0beta3 and there's no problems there. It really looks like there's something in the 1.0.1 code.

Posted: **Fri Sep 15, 2006 6:15 pm**

local testing with apache program ab with windows:

ab -k http://localhost/012/index.php  2390 ms

ab -k http://localhost/101/index.php  515 ms

so i can say - 1.01 is very faster as 013.

it must have another reasons

Posted: **Wed Sep 20, 2006 2:34 am**

I've just installed a site using Oahu (1.0.1) and it's slow too. I have a few other sites running CMSMS pre v1.0 and they run beautifully (same hosting company but different account so possibly a slightly different server setup).

The site in question ran fine on my development server but when migrated to my web host the site just crawls along and according to my hosting company "There is definitely something in your code that is taking a long time to process."

Take a look at www.steveleggat.com to see what I mean. The admin area is unbearably slow (hey get out of there!), over one minute to load up the content edit page.

I've put the output of the Debug mode here - steveleggat.com /debug.html - to see if anyone spots any particular issues.

Linux/Apache
MySQL - 4.0.27
PHP - 4.4.4

Thanks ^__^

Posted: **Sun Sep 24, 2006 6:01 am**

M@rijn wrote: The problem is (i think) the SQL server, the load of the server increased when i wanted to delete some content. CMSMS deleted the content form the site but in the mean time my browser stucks (apache process on server??) and the MySQL process also goes heavyer. The i looked in the content table of cmsms and i saw that the content i had deleted was still available in the SQL database, i deleted by hand and from then i've got no troubles anymore.

I may have had something similar happen. When I was setting up my site locally I hit an error and that in turn caused some of the content to not be deleted. I fixed it the same way you did, however now that the site is online, it seems to be misbehaving. I've had a look through the DB to see if there's any amiss in there but couldn't find anything obvious.
Is there a way I can debug this? I don't have access to the log files to find out what is causing the extra load and I can't see anything obvious when I turn on Debugging in the config (see last post from me) although both of the following take over 1 second to process:

Code: Select all

SELECT * FROM cms_modules WHERE admin_only = 0 ORDER BY module_name

Code: Select all

SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM cms_event_handlers eh
INNER JOIN cms_events e ON e.event_id = eh.event_id
ORDER BY eh.handler_order ASC

Posted: **Sun Sep 24, 2006 8:08 am**

Ok, I just installed a fresh version of 'Maui' on the same server and that too is slow (between 3-6 seconds to generate each page) even before I've been in and added any content, so that rules out it being corrupt data on other site.

Any ideas?

Posted: **Sun Sep 24, 2006 9:01 am**

what about running those sql queries in mysql client and checking how long it takes there? maybe the sql server is overloaded?

Posted: **Sun Sep 24, 2006 9:53 am**

tsw wrote: what about running those sql queries in mysql client and checking how long it takes there? maybe the sql server is overloaded?

Thanks for replying. I ran those queries (via PHPMyAdmin) and a few more listed in the debug log, none returned errors and each took under 0.001 sec to process, so I guess it's not that. Not sure where that leaves me. Is there some way that CMSMS is using a different way of performing those queries? ADOdb Lite? No matter if I enable/disable ADOdb in my config, I still get this line in the debug output: CMS Made Simple is configured to use the full ADOdb Database Abstraction library, but it's not in the lib/adodb directory. Switched back to ADOdb Lite.

Posted: **Sun Sep 24, 2006 2:51 pm**

ADODB lite is the default..

can you see if your server is under heavy load?

Posted: **Sun Sep 24, 2006 4:28 pm**

i must correct my posting:

Testing with Xampp / Windows Standardinstallation

ab -n200 url

CMSMS 0.13

Requests per second 2,3
requesttime 434,219 ms

CMSMS 1.02
Requests per second 1,81
requesttime 552,266 ms

Powerweb
Requests per second 19,63
requesttime 50,938 ms

Now ab -n20 -c20 url

CMSMS 0.13

Requests per second 2,2
requesttime 455,469 ms

CMSMS 1.02
Requests per second 1,83
requesttime 545,313 ms

Powerweb
Requests per second 19,69
requesttime 50,781 ms

So i can say 1.02 is ca. 19 .. 27 % slower as 0.13

CMS Made Simple Forums

Slow website

Slow website

Re: Slow website

Re: Slow website

Re: Slow website

Re: Slow website

Re: Slow website

Re: Slow website

Re: Slow website

Re: Slow website

Re: Slow website

Re: Slow website

Re: Slow website

Re: Slow website