Log in

View Full Version : 59 queries ???


Mustang5ohhh
06-04-2003, 02:20 PM
My forumhome is generating this :

Page generated in 0.40923595 seconds (82.23% PHP - 17.77% MySQL) with 59 queries.
[Debug Mode OFF] [PHP v4.3.1] [GZIP disabled] [Server Load: 0.13 ยป 0.16 : 0.16]

This seems a "little" high to me. I have a few hacks installed ... top10stats ... welcomehack ... categorie banners and few others.

I had the Mod drop down ... before uninstalling it I had 63.

Is there a hack that will tell me what queries are being run ?

I need to get this fixed ... page load for members on dial-up is crazy.

Thanks in advance.

Xenon
06-04-2003, 03:58 PM
enabel debug mode of your board and call index.php with parameters explain=1&showqueries=1

Mustang5ohhh
06-04-2003, 04:55 PM
Thanks Xenon

I had trouble getting debug to work. Added the line to the config.php and uploaded ... still wasn't on according to the microstats hack I have installed.

I did find something that was adding queries ... having my forum depth set to 3 was adding 33 queries. I set it back to 2 and down to 26.

Is 26 an acceptable # ???

Thanks again.

WEForums
06-04-2003, 05:12 PM
I think 26 is pretty acceptable. I have 27. :o

Check out Xenon's hack. https://vborg.vbsupport.ru/showthread.php?s=&threadid=46848 (If you haven't already)

I think someone else did another one...maybe filburt.

assassingod
06-04-2003, 05:25 PM
filburts :https://vborg.vbsupport.ru/showthread.php?s=&threadid=53455

cirisme
06-04-2003, 07:32 PM
I had trouble getting debug to work. Added the line to the config.php and uploaded ... still wasn't on according to the microstats hack I have installed.

I noticed that too, both on my test forum and live forum. But, it is in debug mode even if it says its not. Debug mode and showqueries are invaluable optimization tools. :)

Is 26 an acceptable # ???

Not bad. I have 21, but that's cause I went wild and added two queries. ;)

Xenon
06-05-2003, 05:15 AM
FYI the debugmode has to be enabled in config.php, when you enable it in phpinclude or somewhere else it wouldn't help