Slow website

[SilverXp]

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

What can I do about it?

[cyberman]

Which CMSms version?

[liquid]

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.

[tsw]

php version?
mysql version?
linux/windows
apache?

[liquid]

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.

[Piratos]

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

[stevegan]

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 ^__^

[stevegan]

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

[stevegan]

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?

[tsw]

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

[stevegan]

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.

[tsw]

ADODB lite is the default..

can you see if your server is under heavy load?

[Piratos]

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