Help with reducing Queries

[pgowder]

Just installed the MicroStat hack and my main forum page show 150 queries!!

http://www.powwows.com/gathering

Any suggestions for reducing this?

Thanks!

[amykhar]

I have a hunch that it's the number of active users today that is getting you. I had a similar problem with one of my styles, and turning on debug showed the queries all stemmed from that hack trying to find a template. I tinkered with things a bit (what I did won't apply to you because I turned it off for default members in addition to making sure all the templates were in the list.)

So, that is where I would start looking. Turn debug mode on, look at explain for that page, and you will have an idea of where to begin.

Amy

[pgowder]

How do you run the explain and turn on debug?

[amykhar]

You turn debug on by putting debug=1; in your config.php file. Then you bring up your forum home page like this:

http://www.powwows.com/gathering/index.php?explain=1

[pgowder]

Ok, got that. And I have a huge page of info. How do I determing the problem?

[pgowder]

Your guess was right!

forumhome_todayloggedinuser is showing up a few hundred times!

Did you remove that hack or rework it?

[amykhar]

Let me go look at the code again and see if I can find the problem.

Amy

[pgowder]

Thanks!

[amykhar]

It seems you are using the version where the names don't display on the forumhome, but instead pop up in a new window.

When I had problems with this hack, it was only when I used a style that didn't display the hack. If I used a style that displayed it, queries were fine.

Did you modify the hack yourself, or did you use the version released by Mystic that creates the popup window? You might need to go to that hack's thread and have Mystic look at it because I see somebody else had issues with queries and it was never resolved.

The number of queries you have depends on how many people have logged in for the day.

Amy

[pgowder]

Actually, I'm using the one where they all show, but I removed that template reference from forumhome hoping to reduce the queries.

[Erwin]

Add the template to $templatesused to cache it at the top of index.php. See if that helps.

[pgowder]

Just add that statements to the top of the index.php file??

[amykhar]

Erwin, it's actually already there I believe. There was something else going on that I believe is a result of the fact that he isn't displaying the names on the main page.

Amy

[pgowder]

So should I just unistall this and try a reinstall?

[amykhar]

I don't think that would help pgowder. I think there is an actual problem with the version of the hack that you are using. For what it's worth, this problem probably wouldn't exist if you showed the names on the index.php the way the hack was originally written.

[pgowder]

Ok, so is there a way to modify my install?

[amykhar]

Can you send me your index.php so that I can see something please?

Amy

[pgowder]

Sure, it's in your PM box.

[amykhar]

Think I found your problem. Uninstall the hack that you installed. Then, go to post 16 of the online today hack and get that zip. That one is meant to display the online users in a separate window like you are doing and is slightly different than the original hack.

https://vborg.vbsupport.ru/showthread.php?postid=212603#post212603

I believe that will fix your problem.

Amy

[pgowder]

Thanks for the help!

[pgowder]

With it unistalled, I have only 24 queries much better!

What is a good target for index.php?

[Erwin]

Under 30 should be fine. :) Compare it to stock, which is 17 queries.

[pgowder]

Cool!! 25 isn't two bad for several hacks to the index.php.

How many on a view thread page is normal?

[NSeXcellent]

Where can the microstat hack be found?

[amykhar]

<a href="https://vborg.vbsupport.ru/showthread.php?s=&threadid=35811&highlight=stats" target="_blank">https://vborg.vbsupport.ru/showt...ighlight=stats</a>