How to lower 104 queries on frontpage?

[Gutspiller]

<a href="http://www.theforumz.com/forumz/" target="_blank">http://www.theforumz.com/forumz/</a>

Can peeps take a look at that and tell me what couple of things I might be able to take out that may affect my load query? I think 104 is kinda high. especially when I hear people talk about 17 and 24.

I know some of the stuff I have going on at the bottom is perhaps part of my problem. Anybody know off hand how many queries the "Current World Time" hack adds?

Anything to help would be appreciated.

Thanks. :dead:

[cinq]

Hmm is it just me or i see a page stating 33 queries which seems alrite.

? Copyright 2001 - 2003 CuttingTheEdge.com
vBulletin. Copyright ?2000 - 2003, Jelsoft Enterprises Limited.
Page generated in 0.7567490 seconds (-159.10% PHP - 259.10% MySQL) with 33 queries.

[Brad]

33 is still high.

Make sure you avoid:

Using querys in while loop's

Not adding your custom displayed templates to the $templatesused car

Install both the forumhome optimize hacks.

Remove the forum mod query in index.php, sence youve removed the moderator colum anyway :alien:

[Gutspiller]

Yesterday at 10:26 PM Anime-loo said this in Post #3
Remove the forum mod query in index.php, sence youve removed the moderator colum anyway :alien:

Where would I find that and what exact parts would I remove, do you know? certain code I should look for?

[Tigga]

Well as a guest on your forums, you'll only see around 30 queries. As a registered member though, it's closer to 100. One thing you can do is add the following templates to the template cache at the beginning of the file -authority_list, forumhome_quicksearch, forumhome_dropdownbit, forumhome_quote, forumhome_newforumthreads.

You also have a query that appears to be counting the number of threads since a certain time for every forum, which is adding about 50 queries to your page -
SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1057849698 and forumid=XX

Add those templates to the template cache, find that query above & remove it, and the number of queries should be a fraction of what they are now.

[SmEdD]

Today at 03:57 AM Gutspiller said this in Post #4
Where would I find that and what exact parts would I remove, do you know? certain code I should look for?

There a hack out there to put moderators into cache. Look at the code you edit and just remove the code completely. It's called forum home optmization I belive.

[Gutspiller]

Yesterday at 09:26 AM Tigga said this in Post #5
Well as a guest on your forums, you'll only see around 30 queries. As a registered member though, it's closer to 100. One thing you can do is add the following templates to the template cache at the beginning of the file -authority_list, forumhome_quicksearch, forumhome_dropdownbit, forumhome_quote, forumhome_newforumthreads.

You also have a query that appears to be counting the number of threads since a certain time for every forum, which is adding about 50 queries to your page -
SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1057849698 and forumid=XX

Add those templates to the template cache, find that query above & remove it, and the number of queries should be a fraction of what they are now.

How do I had those things you said to the template cache?

[Erwin]

In index.php, look for

PHP Code:

$templatesused=' 


And add templates you are calling that are not cached into that line.

[Gutspiller]

I added those others into the cache thingy and it took it down to a whole 98.

What are you saying I should do with the "SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1057849698 and forumid=XX"? Or are you just saying that's the line that's causing the 50 or so queries? Where'd you find that? and if it is slowing down the page a lot, I will remove it?

[Gutspiller]

UPDATE: WOW! I notice a huge improvement in the time it takes to load my forum frontpage. What about the mod column? I removed the code, but somebody was saying that the coding was still inside the index file. Can somebody help me out on where the code begins and ends that I need to remove? I looked at that optimzing the frontpage hack the filburt way and I couldn't find where I was suppose to find the code to take out.

I had another question for you guys. My frontpage news page loads really slow, is it possible to do any of this same type of caching so that it loads up faster too? the page that I'm talking about is this one: http://www.3dNewz.com It's the same site as http://www.TheForumz.com. Can anybody help me with that?