Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2007-12-03 18:58:41
- zeusdidit
- Member
- Registered: 2007-10-16
- Posts: 111
I need comments, suggestions on site and slow loading
http://spanish.makeupbycelso.com/before-and-after/fashion-shoot-make-over
http://spanish.makeupbycelso.com
Both these pages appear to be loading pretty slow and I’m on a high speed connection. I’m not sure if it is a webserver issue or a textpattern issue. Any suggestions on speeding things up for this site specific I’d love to hear them.
Thanks,
Zeus
Offline
Re: I need comments, suggestions on site and slow loading
Your HTML source shows this at the bottom:
<!-- Runtime: 1.0958 -->
<!-- Query time: 0.729855 -->
<!-- Queries: 28 -->
<!-- Memory: 2875Kb, end of textpattern() -->The query time is pretty high. Try switching the website to debug mode and find out which queries take up most of that time. You either have some slow or inefficient queries or your on a slow server.
Offline
#3 2007-12-03 19:07:03
- zeusdidit
- Member
- Registered: 2007-10-16
- Posts: 111
Re: I need comments, suggestions on site and slow loading
Thanks Ruud will do and post back the debug info. Good idea!
Offline
#4 2007-12-03 19:09:34
- zeusdidit
- Member
- Registered: 2007-10-16
- Posts: 111
Re: I need comments, suggestions on site and slow loading
I turned on debug. How do I know which query if any is causing an issue?
Offline
Re: I need comments, suggestions on site and slow loading
View your page’s source, at the bottom is the debug info.
It says:
[SQL (0.022855): select name from spanishtxp_lang as txp_lang where lang='en-us' limit 1]
[SQL (0.078975): select name, data from spanishtxp_lang as txp_lang where lang='en-us' AND ( event='public' OR event='common')]
[SQL (0.117088): select name, code, version from spanishtxp_plugin as txp_plugin where status = 1]Hell, it takes long long time, but at this time your query time was better:
<!-- Runtime: 0.5351 -->
<!-- Query time: 0.513175 -->But are you using MLP?
Cheers!
Last edited by Gocom (2007-12-03 19:29:45)
Offline
#6 2007-12-03 19:31:21
- zeusdidit
- Member
- Registered: 2007-10-16
- Posts: 111
Re: I need comments, suggestions on site and slow loading
Yea, maybe one of the plugins is taking time to load. I’ll see about maybe removing some plugins to speed things up.
Offline
#7 2007-12-03 19:32:03
- zeusdidit
- Member
- Registered: 2007-10-16
- Posts: 111
Offline
Re: I need comments, suggestions on site and slow loading
The problem seems to be the MySQL server your website is using. It’s horribly slow.
In your debug:
[SQL (0.063452): select name, data from spanishtxp_lang as txp_lang where lang='en-us' AND ( event='public' OR event='common')]
[SQL (0.229053): select name, code, version from spanishtxp_plugin as txp_plugin where status = 1]
[SQL (0.023403): select * from spanishtxp_section as txp_section where name = 'default' limit 1]
[SQL (0.036714): select user_html from spanishtxp_page as txp_page where name='main-frontpage']In a similar debug from my test server at home:
[SQL (0.006725): select name, data from txp4_txp_lang as txp_lang where lang='en-gb' AND ( event='public' OR event='common')]
[SQL (0.002742): select name, code, version from txp4_txp_plugin as txp_plugin where status = 1]
[SQL (0.001319): select * from txp4_txp_section as txp_section where name = 'default' limit 1]
[SQL (0.001061): select user_html from txp4_txp_page as txp_page where name='default']Mine is 10 times faster, which is quite interesting, especially if you know that my home server is a 10 year old computer with 64MB RAM powered by an underclocked AMD K6 at 200Mhz ;)
Offline
#9 2007-12-03 21:15:13
- zeusdidit
- Member
- Registered: 2007-10-16
- Posts: 111
Re: I need comments, suggestions on site and slow loading
Yea, what the hell?…! ur like speeding through. Maybe i’m making too many connections somehow. I think I’ll debug my other site too at www.blog.zeusdidit.com with textpattern and see if I have the same issue. This is a bit concerning after seeing your numbers. Thanks Ruud. Ur a rockstar.
Offline