Queries, Queries, Queries ..

[joor]

Oh cool! I added the debug info but didn't know about the querystring to add. Just moved from a shared to a dedicated today, want to see my difference?

Shared Server:
Page generated in 1.614294052124 seconds with 21 queries,
spending 0.69835984706879 doing MySQL queries and 0.91593420505524 doing PHP things.

Dedicated Server:
Page generated in 0.10820305347443 seconds with 21 queries,
spending 0.029100894927979 doing MySQL queries and 0.079102158546448 doing PHP things

Woot! Thanks, I didn't want to install the vbMicrostats to get that info. So now I have your question, is it safe to leave that debug in config?

[Erwin]

No. It is a security hole that hackers can take advantage of. This is why from vB 2.2.4 upwards it was disabled as standard.

[Xenon]

also with debug mode you can change the gloabal template set and other inner vb-things, which can be very risky, too if you don't know what you do

[Dean C]

Geez 18 queries...

I have 48 on my forumhome..

- miSt

[Sebastian]

yeah, and I want it lower lol

[N9ne]

48 on forumhome? Mist, you're killing your server

[Sebastian]

Forum home usually performs more queries than any other page .. 48 is a tad high, I've seen some boards over 250! it makes me very nervous aranoid:

they obviously do not know what the heck they are doing and don't know how to manage their forums for that matter.

[Dean C]

Well i do know what im doing..

But my server can cope very well...

Im going to check my file tonight for any misplaced template calls that aren't in the $templatesused variable

- miSt

[Xenon]

if you have questions, just ask

there are some guys out here who likes to optimize queries

[N9ne]

I'm one of them, but TECK is the god of query optimization!

Anyway...I definitely think anything above 35 on forumhome is not good...I, on my "version 2" of my forum, will have 23 queries logged out, and 25 logged in

The only problems I have are with showthread, as there is much to be put there.