Thread

what about the thing at the top?

with the disable thing done and a few things I have looked at and done

197 inquiries has come down to 124

Have taken the Article template (full article post) and dropped database queries from 75 to 20

It appears to be working fine

Much better. Let’s run with that for a few more days..

has not locked in a few days

but still getting this in the processes

SELECT DISTINCT (
t.entry_id
)
FROM exp_weblog_titles AS t
LEFT JOIN exp_weblogs ON t.weblog_id = e

Hi bthom62,

Can you clarify where you are seeing this query? If you switch on SQL Queries at Admin > Output & Debugging then those queries are not shown are they?

Cheers

Greg

Hi Greg I will try that

What I am showing comes from mysql “show Processes”

when enough on them show up, they lock the site and cause it to hang

this is what get with the debugging turned on on my front page

Total Queries: 102
TEMPLATE DEBUGGING

see attached

You’re still back to the initial issue - 15 or so exp:weblog:entries on a single page. Some of this can be alleviated by using the query module - but the main page may need to be trimmed down a bit more. I’d eliminate 1/3 of those exp:weblog:entries loops and only put in what people come to the site to see.

Sue, this never was an issue before,when we had double the traffic.

Having got that out of my system, this is what I have doen so far

So far I have taken the database inquiries from 197 down to 85 on the front page, and from 75 down to 28 on my archive pages.

This query module….

What do I have to do, how do I do it, where do I go?

Thank you

bthom62,

but still getting this in the processes

SELECT DISTINCT (
t.entry_id
) FROM exp_weblog_titles AS t
LEFT JOIN exp_weblogs ON t.weblog_id = e

You are going to get that in your processes. There is nothing wrong with that as it is part of the weblog module The issue has been all the way through this thread that you need to optimize your homepage template.

At this stage it is recommended that you avail of the services of a member from the Pro Network to help you with your site as the direction the thread has taken is not appropriate for the Support forum. Alternatively you could use of CodeShare Corner to find help for your homepage template

Hi, bthom62 - I just wanted to follow up and see how you are coming with this.  John Henry gave excellent suggestions, and I would recommend looking at your homepage template for optimization opportunities as well.  Do you have questions about that?

Thank you!

Site hung yesterday same time as always 9:30 am est.

But that was the first time in 2weeks (more or less)

My two main templates index.php (front page) went from 197 database inquiries to 85

My main article template was gone from 78 to 20 inquiries.

I am still working on code to lessen that

until I do the other lesser template are still database hogs.

Thank you

Sounds like progress. Let’s have you work further on fixing those memory hog templates - and see where we are in another week or so. We can have you make a new post based on this one.. closing in the meantime.