*SOLVED! Why is my site so @#!*& slow.

mrdale · 2006-10-31 19:45:56

OK, DO NOT use the nested CSS technique I described here It’ll slow down you site to a crawl. I’ll let other wiser people explain why, I’ve used this technique before outside of TXP without penalty, but I learned the hard way that this is not a great idea… Better to use mcw_templates if you want to edit your css with less scrolling around.

So I created a site I’m very pleased with. See for yourself at Diversity Coalition Lots of functionality. I’m hosted at textdrive which I’m ecstatic about. But it’s a real dog in terms of speed, Any thoughts?

Late 4.03 (1300ish) using a few plugins for Calendar, Live archive, categories, etc. I can post a lot more information and diagnostics, but I thought I might just make my post breif to see if I have committed any obvious stupidity.

[Edit]

<!— Runtime: 1.7074 —>
<!— Query time: 1.220102 —>
<!— Queries: 48 —>
<!— Memory: 3676Kb, end of textpattern() —>

[Edit Later] to show wildly different result, Como?

<!— Runtime: 0.4276 —>
<!— Query time: 0.20571 —>
<!— Queries: 48 —>
<!— Memory: 3676Kb, end of textpattern() —>

Last edited by mrdale (2006-11-02 17:54:44)

ruud · 2006-10-31 20:32:39

Set the site status to “testing” and show us the summary at the bottom of the page (look at the HTML source).

Sencer · 2006-10-31 20:34:05

You should start by reading this carefully:

http://textpattern.com/faq/136/diagnosing-performance-problems

It should give you an idea on how to narrow where the problem is coming from, and a couple options you can try to improve the situation.

jm · 2006-10-31 20:53:21

Those are quite a few queries on the front page, but the site is fast for me (@1.5mbps). Try disabling the calendar plugin, or some of the others to see if there’s any difference.

edit: Speed results

Last edited by jm (2006-11-01 03:27:12)

NyteOwl · 2006-11-01 02:25:10

I tried it on dialup and the entire page including all graphics was done in 19 seconds – the text was down in less than 10-12 seconds. I don’t consider that slow.

mrdale · 2006-11-01 15:49:59

OK, the speed issue is sporadic and perhaps localized. I’m investigating it with a TXD ticket. Thanks to Sencer for pointing me at the FAQ (doh!) and everyone else who helped.

ruud · 2006-11-01 16:12:28

Do let us know what the outcome is… I’m seeing similar performance problems with a website hosted there.
Because most of the time seems to get lost in doing the MySQL query, perhaps a caching plugin helps.

edit… I currently see this on your website:

<!— Runtime: 7.9786 —>
<!— Query time: 5.89134 —>
<!— Queries: 47 —>
<!— Memory: 3676Kb, end of textpattern() —>

Last edited by ruud (2006-11-01 16:29:17)

mrdale · 2006-11-01 16:18:34

>ruud most of the time seems to get lost in doing the MySQL query

What exactly indicates this? the query number?

ruud · 2006-11-01 16:30:30

Queries = the number of times Textpattern (or a plugin, more likely) is asking the database (MySQL) for some information.
Query time = the total time all these queries consume.

What generates queries: each time you use a form on a page, article lists, individual articles, link lists, category lists and such, textpattern (or plugins) has to retrieve some information that is stored in the database.

Textpattern itself tends to be quite efficient in doing this. Some plugins can be a bit less efficient and can often be optimized to perform better. Some extreme examples: a page that took 1200 (!) queries due to inefficient plugins could be optimized to use only 49 queries. And an even bigger page used 5000 queries which could be reduced to 112.

Last edited by ruud (2006-11-01 16:45:36)

mrdale · 2006-11-01 18:18:01

So I’ve come to the conclusion that my speed issues are not textpattern related. Most of my numbers seem to be in the vicinity of slim.

We’ll see what TXD says…

mrdale · 2006-11-02 17:55:31

Problem Solved

DO NOT use the nested CSS technique I described here It’ll slow down you site to a crawl. I’ll let other wiser people explain why, I’ve used this technique before outside of TXP without penalty, but I learned the hard way that this is not a great idea… Better to use mcw_templates if you want to edit your css with less scrolling around.

Last edited by mrdale (2006-11-02 17:56:08)

Mary · 2006-11-02 20:04:24

I’d be curious to know if this wouldn’t be resolved in 4.0.4 by turning on “send Last Modified headers”.

Textpattern CMS

Textpattern CMS support forum

#1 2006-10-31 19:45:56