Query load

[Sia Bani]

Hi all. Newbie here. I just installed Teck's microstats and this is what I'm getting for my index data:

Page generated in 0.11948705 seconds (60.20% PHP - 39.80% MySQL) with 32 queries.
[Debug Mode OFF] [PHP v4.2.2] [GZIP disabled] [Server Load: 0.10 » 0.47 : 0.63]

Is 32 queries too high? I only have about 60 members now, my forum is about 2 weeks old. Will I run into trouble with more users?

thanks.

[Erwin]

32 queries for index.php is not too bad. Considering an unhacked index.php gives only 17, 32 is almost doubled - so it depends on how busy your forums are going to get. How many members at one time? If overall you have 60 members, 32 is fine. :) The general rule is to get it at least below 30 if possible.

[Sia Bani]

thanks for the quick response. I've installed several hacks that I really want to keep, so is there anyway to minimize the queries without getting rid of teh hacks?

[Erwin]

Interesting drawing for a splash screen on your site. :) Like I was saying, there's no real need to reduce it with the number of members you've got now. You can rationalize the PM queries from 3 to 1 by replacing the current code in your index.php for PMs with this:


$allpm=$DB_site->query_first("SELECT COUNT(*) AS messages,
SUM(IF(dateline>$bbuserinfo[lastvisit] AND folderid=0,1,0)) AS newpm,
SUM(IF(messageread=0 AND folderid=0,1,0)) AS unreadpm
FROM privatemessage WHERE userid=$bbuserinfo[userid] $ignoreusers");

$newpm['messages']=$allpm['newpm'];
$unreadpm['messages']=$allpm['unreadpm'];


Also, if you don't need to know the number of threads in the forums, or the name of the newest member etc. - each one of those takes one query. Just remove the relevant lines in your index.php. Make sure all templates are listed in your templatesused ="" variable at the top, or else each template called is an extra query too.

[Sia Bani]

Hey, thanks a lot.

[Erwin]

No problems, glad to help. :)

[Dean C]

Erwin that code however if i remember correctly can add more queries under certain circumstances..

- miSt

[Erwin]

How? It's one query line. When you get a new PM, you get 2 extra queries, but that's not from this line of code, it's for the PM popup.

[Xenon]

Erwin is right mist ;)

@Sia: you should look if you have a query in a while - loop through one of your hacks.
if yes, this is a don't do ;)
ask in the supportthread if this can be optimized then :)

[Dean C]

Lol ill leave it to the advanced hackers ;)

I just had a hunch id seen that before and PPN said not to do it for some reason or another :)

- miSt

[Xenon]

he hasn't said it exactly to this optimization.

he just says sometimes it would be better to have more queries instead of one real great query :)
it always depends on the situation