Query Count On Various Pages

[Dean C]

I need an expert opinion on whether i have too many queries per page... here they are... please state wich pages have too may queries if you would please:

index.php: 30 queries

register.php: 11 queries

usercp.php: 23 queries

register.php: 11 queries

private.php: 11 queries

showthread.php: 27 queries

newthread.php: 12 queries

newreply.php: 20 queries

- miSt

[N9ne]

looks okay to me.

[NTLDR]

showthread will vary depending on how many posts ect, index at at the top margin. In general try to keep the number of queries bellow 30. If you site doesn't have large volumes of traffic then going over this limit a little won't have that much of an effect on the server.

[NexDog]

How do I determine how many queries I'm producing without installing the microstats hack?

[Dean C]

there's a line of code i noticed the other day in functions.php i think... its commented out... damn im gonna release this... pathetic excuse for my first hack lol

- miSt

[NTLDR]

Originally posted by NexDog
How do I determine how many queries I'm producing without installing the microstats hack?

You need to enable showqueries and add showqueries=1 to the end of the URL, or with older versions add explain=1

[Erwin]

Originally posted by NTLDR


You need to enable showqueries and add showqueries=1 to the end of the URL, or with older versions add explain=1

Turn debug mode to ON first, otherwise from 2.2.4 up showqueries won't work because of the security risk.

And @ the first poster - those numbers look good.

[Dean C]

turning debug on is a huge security risk i think or is it the other way round?

- miSt

[Xenon]

enabled debug mode is a security risk, you should turn it to off after you've done what you want

btw: you should always be able to add $query_count into your footertable which should show you the ammount of querys

[NTLDR]

Originally posted by Xenon
enabled debug mode is a security risk, you should turn it to off after you've done what you want

I know having debug on is a security risk, but would you mind telling us why? I've allways had it switched off anyway but would like to know what risks exisit by having it switched on.