Slow Loading?

[rbaby]

Hey guys,

I just have a fresh install of CMSMS, my host is MediaTemple. Any ideas what could be causing it to load very slow? With content and with just default content, it was slow all the same...

I tried to search the forums and found a few tips (namely the disabling of persistent connections and modifying the stylesheet.php file).

Any help would be greatly appreciated.

[Wishbone]

Turn on debug mode in config.php. It will tell you what's taking so long.. Probably slow database.

[rbaby]

It this normal?

---

Generated in 1.492509 seconds by CMS Made Simple using 14 SQL queries and 8675988 bytes of memory (peak memory usage was 9389616)
Debug: (0.073101) - (usage: 753232) - (peak: 790140)

loading smarty

Debug: (0.079225) - (usage: 1062824) - (peak: 1085448)

loading adodb

Debug: (0.083982) - (usage: 1163168) - (peak: 1191176)

loading page functions

Debug: (0.089111) - (usage: 1379804) - (peak: 1449896)

loading content functions

Debug: (0.093521) - (usage: 1610144) - (peak: 1629432)

loading translation functions

Debug: (0.115041) - (usage: 1688132) - (peak: 1718760)

loading events functions

Debug: (0.117747) - (usage: 1782712) - (peak: 1873196)

loading php4 entity decode functions

Debug: (0.123372) - (usage: 2018940) - (peak: 2214620)

done loading files

Debug: (0.219311) - (usage: 2781732) - (peak: 2789112)

(mysql): SET NAMES 'utf8'

Debug: (0.235544) - (usage: 2805860) - (peak: 2830316)

(mysql): SELECT sitepref_name, sitepref_value from cpla_siteprefs

Debug: (0.254296) - (usage: 2893860) - (peak: 2916728)

(mysql): SELECT * FROM cpla_userplugins

Debug display of 'Load Content Operations':(0.25505) - (usage: 2927928) - (peak: 2943084)
Debug display of 'End Load Content Operations':(0.272187) - (usage: 3577488) - (peak: 3595640)
Debug: (0.280824) - (usage: 3580256) - (peak: 3624436)

(mysql): SELECT content_id,page_url FROM cpla_content
WHERE active = 1 AND default_content = 0 AND page_url != ''

Debug display of 'Loading Modules':(0.28099) - (usage: 3578120) - (peak: 3627636)
Debug: (0.300672) - (usage: 4036620) - (peak: 4055768)

(mysql): SELECT * FROM cpla_modules WHERE admin_only = 0 AND active = 1 ORDER by module_name

Debug display of 'Instantiate: CMSMailer':(0.305994) - (usage: 4247796) - (peak: 4263576)
Debug display of 'Instantiate: FileManager':(0.448661) - (usage: 4547540) - (peak: 4580284)
Debug display of 'Instantiate: FormBuilder':(0.455671) - (usage: 4850496) - (peak: 4872668)
Debug display of 'Instantiate: MenuManager':(0.497113) - (usage: 6204088) - (peak: 6239984)
Debug display of 'Instantiate: News':(0.511514) - (usage: 6515780) - (peak: 6543440)
Debug: (0.515514) - (usage: 6526012) - (peak: 6572792)

(mysql): SELECT news_id,news_url FROM cpla_module_news
WHERE status = 'published' AND news_url != '' AND ( IFNULL(start_time, '1969-12-31 16:00:01') < NOW()) AND (( IFNULL(end_time, '1969-12-31 16:00:01') = '1969-12-31 16:00:01') OR (end_time > NOW())) ORDER BY news_date DESC

Debug: (0.518994) - (usage: 6524384) - (peak: 6588232)

(mysql): SELECT content_id FROM cpla_content WHERE default_content = 1

Debug display of 'Instantiate: Printing':(0.559602) - (usage: 6748996) - (peak: 6787120)
Debug display of 'Instantiate: Search':(0.572786) - (usage: 6980816) - (peak: 7012812)
Debug display of 'Instantiate: Showtime':(0.594415) - (usage: 7143256) - (peak: 7167356)
Debug display of 'Instantiate: TinyMCE':(0.618726) - (usage: 7435288) - (peak: 7456936)
Debug display of 'End of include':(0.619096) - (usage: 7436592) - (peak: 7486932)
Debug: (0.677918) - (usage: 7481688) - (peak: 7512780)

(mysql): SELECT * FROM cpla_content WHERE content_id = '15' AND active = 1

Debug: (0.689348) - (usage: 7694460) - (peak: 7703528)

load from data is loading properties

Debug: (0.692937) - (usage: 7698728) - (peak: 7745020)

(mysql): SELECT * FROM cpla_content_props WHERE content_id = '15'

Debug: (0.722919) - (usage: 7840620) - (peak: 7863732)

(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cpla_templates WHERE template_id = '23'

Debug: (0.777231) - (usage: 8592424) - (peak: 8610612)

(mysql): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM cpla_event_handlers eh
INNER JOIN cpla_events e ON e.event_id = eh.event_id
ORDER BY eh.handler_order ASC

Debug: (1.240459) - (usage: 8831416) - (peak: 8929400)

(mysql): SELECT * FROM cpla_module_showtime_name WHERE show_id = 1

Debug: (1.24303) - (usage: 8843064) - (peak: 8929400)

(mysql): SELECT picture_id, picture_name, picture_url, picture_path, comment FROM cpla_module_showtime WHERE active AND show_id = '1' ORDER BY picture_number

Debug: (1.489518) - (usage: 8854716) - (peak: 9389616)

(mysql): SELECT DISTINCT A.css_id,A.css_name,A.css_text,A.modified_date,
A.media_type,B.assoc_order
FROM cpla_css A
LEFT JOIN cpla_css_assoc B ON A.css_id = B.assoc_css_id WHERE B.assoc_type = 'template'
AND B.assoc_to_id = '23' ORDER BY B.assoc_order

Debug: (1.490588) - (usage: 8800948) - (peak: 9389616)

calling module TinyMCE from event ContentPostRender

Debug: (1.492299) - (usage: 8802068) - (peak: 9389616)

calling module Showtime from event ContentPostRender

[calguy1000]

No, this is not normal. and from going through the debug messages there, it is almost guaranteed that your problem is with the database connection.

I manage 2 MediaTemple VPS servers, with about 30 CMSMS sites each on them, with varying levels of traffic.. and NONE of them perform as badly as this.

I am gonna bet that you're not on a MediaTemple VPS, but on a 'shared host' with your database actually residing on a remote host. We have heard of similar problems with other hosts that tend to 'oversell' their boxes in the hopes that the majority of the sites that they put on there will be simple static, low traffic sites that won't notice that the server is woefully undersold... but that's just a 'thought' about what's happening to you.

I would suggest that you talk with the host about moving to a less-subscribed server, and/or a different database host.

[Wishbone]

If you're seeing delay more than 1.4 seconds, it could be due to your internet connection, or internet slowness in general.. The 1.4 seconds is how long it took to generate the page... Anything after that is transmission delay.