Help with reducing Queries
 

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

http://www.powwows.com/gathering

Any suggestions for reducing this?

Thanks!

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

How do you run the explain and turn on debug?

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

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

Your guess was right!

forumhome_todayloggedinuser is showing up a few hundred times!

Did you remove that hack or rework it?

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

Amy

Thanks!

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

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