vbMicroStats: page load time, queries, GZIP and PHP version

[high]Looking for VB3 version? Is here.[/high]

This hack will add at the bottom of each vBulletin(powered) page the following stats:
- load time of specified page in microseconds (with custom no. of digits to show)
- number of queries executed
- server GZIP library compression status
- vBulletin DEBUG mode
- PHP version
- PHP percent page usage
- MySQL percent page usage
- Server Load
[high]This is not only estethic, it will also help you troubleshoot any wierd queries that you have in your scripts.
The hack is template based so you can edit it the way you want in few seconds.[/high]
NOTE: From users experiences, this hack will work only with PHP 4.0.6 or higher. Let me know if it works with a lower PHP version.

THE FIX FOR VB2.3.0 IS HERE.

HACK UPDATES
Version 2.1
------------------------------------
Changes:
- added Server Load

NOTE: I spoked with Kevin 'tubedogg' from vBulletin Support team and he explained to me that not all the servers are configured to support the [high]@exec("uptime")[/high].
Contact your host for more details and ask them about this issue.
For a full explanation of your 3 server load values, read more here.

*If you want to have the stats viewable only by admins, read this post.

Version 2.0
------------------------------------
Changes:
- added vBulletin DEBUG Mode
- removed the Details link
- cleaned a little the code to match VB2.2.6
- better explanations into the install file.

Version 1.7
------------------------------------
[high]VB2.2.5:[/high]
Minor change in admin/db_mysql.php. Read more here on how to update your hack.
Minor change in forum/global.php. Read more here on how to update your hack.

Changes:
- corrected negative values on certain servers.

Version 1.6
------------------------------------
Changes:
- PHP version and GZIP library status viewable only to admin.
- added a link to Detailed Stats View (generated by vBulletin), for that specific page. Only admins can view that link.

To see how it looks a Detailed View, click here.

Version 1.5
------------------------------------
Added:
- GZIP library status is now related to your vBulletion options.
- GZIP library compression level.

Version 1.4
------------------------------------
Bugs corrected:
- GZIP library status not displayed properly on certain servers.

Version 1.3
------------------------------------
Bugs corrected:
- vbPortal display code in modules

The hack is template based now.
All you have to do is call it with the {getmicrostats} string, anywhere you want (for example in footer).
You also have the choice to install it as template based or coded directly into your functions.php file.

Version 1.2
------------------------------------
Added the PHP and MySQL page percentage.
(Addon by Chen 'FireFly' Avinadav)

Version 1.1
------------------------------------
vB.org decided to add this hack to their board.

Bugs corrected:
- incorrect time load
- incorrect query count

You like this hack? Please click on the [high]Install[/high] button.
To download the latest version of this hack, click below:

[TECK]

check your templates. the way is designed the hack, it will not interfere with any blocks.. due to {getmicrostats} variable. there are several users who installed this on phpportals without any problem.

[X-Fan]

Got it working now...

Page generated in 3.88498294 seconds (7.21% PHP - 92.79% MySQL) with 55 queries.

55 queries... ouch

How can I find out why there's so many queries and how to cut that number down?

[TECK]

first congrats on get it working...
second, hmm there are your hacks that generate alot of queries. i personally think 55queries is huge, extremly high. your server gets on the red line at 40-45queries.
phportals are known for adding alot of queries. unfortunatelly there is nothing you can do about it, unless you disable as many options as you can.
a decent number of queries should be 25.
that's the only reason i didnt install phpportals. the extreme no. of queries.

btw, did you know that vB3 will have only 12queries?

[X-Fan]

Which of the vbPortal options are we talking about, specifically?

(Just so I've got an idea of things I can try and reduce that huge number of queries!)

[Gary King]

@X-Fan: I just visited your forums, and got this:

Page generated in 8.75267601 seconds (5.27% PHP - 94.73% MySQL) with 46 queries.

[TECK]

Originally posted by X-Fan
Which of the vbPortal options are we talking about, specifically?
(Just so I've got an idea of things I can try and reduce that huge number of queries!)

i have no idea. as i said, i never installed phpportals. i know about the options from other users who installed this hack and encountered the same prob as you.

[Erwin]

I got my forum index page down to 15 queries. That is less than default. And I have LOTS of hacks running.

[TECK]

that's a great job there erwin. you probably tied the 3 pm queries into one, on forumhome page, that will take it down to 15.
i wonder how many queries vb3 will have on showthread? that's the only place where we see the highest number of queries performed.

[Erwin]

My showthread has 18 queries - that is the bare minimum I can get it down to, without removing hacks I want.

[X-Fan]

So Erwin, how did you do it? Any advice for us PHP newbies?