Page timer & MySQL counter - Hacks - XOOPS News

XOOPS

News

News World of XOOPS Developers Hacks Themes Archive Submit News

Hacks: Page timer & MySQL counter

Posted by: brashOn 2004/11/17 19:32:44 12549 reads

1) upload insert.showstat.php file to your /class/smarty/plugins directory from your Xoops root folder.

2) Go into your Xoops control panel, and goto System Admin->Preferences Main->General Settings and set the "Update module template .html files from themes/your theme/templates directory?" to yes.

3) Insert the "<{insert name='showstat'}>" minus the "" into your theme.html file and view your homepage (you should see something like "0.432 Seconds | 46 Queries" printed at the base of your page).

4) Go into your Xoops control panel, and goto System Admin->Preferences Main->General Settings and set the "Update module template .html files from themes/your theme/templates directory?" to no.

5) Set all your block and caching options to suit your site, and this smarty plugin should now display the execution time and MySQL query count generated for producing every page.

The comments are owned by the author. We aren't responsible for their content.

Re: Page timer & MySQL counter

menochi Published 11/17/2004 20:16 Friend of XOOPS Joined 12/28/2003 Comments 259

Hey brash:

Thank you for the nice hack. I realy like it

Re: Page timer & MySQL counter

brash Published 11/18/2004 4:10 Friend of XOOPS Joined 04/10/2003 Comments 2206

No worries menochi, I'm glad you liked it . I should point out that I've only tested this plugin with XOOPS 2.0.7.3 and 2.0.9 beta. It should work with earlier versions, but don't hold me to it.

Re: Page timer & MySQL counter

menochi Published 11/19/2004 16:58 Friend of XOOPS Joined 12/28/2003 Comments 259

It works with 2.0.6

Re: Page timer & MySQL counter

Kainaij Published 12/10/2004 11:24 Quite a regular Joined 10/05/2004 Comments 256

Works great on my site too. Great job!

Re: Page timer & MySQL counter

JMorris Published 12/10/2004 11:36 XOOPS is my life! Joined 04/11/2004 Comments 2722

Great little hack brash.

I'm really curious as to why this type of thing was never included in the default XOOPS install. Many CMSs have similar functionality.

Re: Page timer & MySQL counter

brash Published 12/10/2004 11:51 Friend of XOOPS Joined 04/10/2003 Comments 2206

Thanks JMorris

I suppose it's not seen as being relevant for a lot of people. I just like to use it to keep a general eye on things

Re: Page timer & MySQL counter

Mithrandir Published 12/10/2004 15:29 XOOPS is my life! Joined 06/21/2003 Comments 6320

I don't know, why I didn't suggest this - probably due to my aversion towards <{php}> tags - but the same can be accomplished with inserting this in theme.html:

 <{php}> 
echo round(($GLOBALS['xoopsLogger']->dumpTime()), 3)." Seconds | ".count($GLOBALS['xoopsLogger']->queries)." Queries"; 
<{/php}>

Since the theme.html is never cached, module or block caching will not interfere.

Re: Page timer & MySQL counter

brash Published 12/15/2004 4:21 Friend of XOOPS Joined 04/10/2003 Comments 2206

Indeed you are right Mith, that will work too. Either way is good . Your idea does give me another idea though. A few people asked me if my insert plugin would work in the Admin area, which it won't as the admin area doesn't use smarty. However, a modified version of your code will. Here's what to do;

1) Backup include/cp_functions.php

2) Find lines 152 & 153 in include/cp_functions which look like this;

 <td width='1%'><img src='".XOOPS_URL."/modules/system/images/hbar_left.gif' width='10' height='23'>td> 
<td width='98%' background='".XOOPS_URL."/modules/system/images/hbar_middle.gif' align='center'><div class='fontSmall'>Powered by&nbsp;".XOOPS_VERSION." © 2001-2003 <a href='https://xoops.org/' target='_blank'>The XOOPS Projecta>div>td><td width='1%'><img src='".XOOPS_URL."/modules/system/images/hbar_right.gif' width='10' height='23'>td>

3) Modify them to take up lines 152, 153 & 154 so they look like this;

 <td width='1%'><img src='".XOOPS_URL."/modules/system/images/hbar_left.gif' width='10' height='50'>td> 
<td width='98%' background='".XOOPS_URL."/modules/system/images/hbar_middle.gif' align='center' height='50'><div class='fontSmall'>Powered by&nbsp;".XOOPS_VERSION." © 2001-2003 <a href='https://xoops.org/' target='_blank'>The XOOPS Projecta><br>".round(($xoopsLogger->dumpTime()), 3)." Seconds | ".count($xoopsLogger->queries)." Queries";"div>td> 
<td width='1%'><img src='".XOOPS_URL."/modules/system/images/hbar_right.gif' width='10' height='50'>td>

4) If you are a bit of a perfectionist, you might also want to modify modules/system/images/hbar_middle.gif so that it is 50 pixels high instead of 23 pixels

Re: Page timer & MySQL counter

jaerowe Published 12/30/2004 22:09 Just popping in Joined 12/29/2004 Comments 5

This is exactly what i was looking for! thanks

Re: Page timer & MySQL counter

Sebastian Published 04/17/2005 1:08 Just popping in Joined 11/25/2004 Comments 23

Uhm, I can't really see it on your page... But it works for me, thanks!

What is the highest acceptable number of queries and seconds used for a small site??

Re: Page timer & MySQL counter

brash Published 04/17/2005 1:30 Friend of XOOPS Joined 04/10/2003 Comments 2206

There is no one size fits all answer, you can have as little or as many as you like depending on how much importance you place on site performance. The most important thing to watch is the execution time as this is what is going to effect content delivery to your users the most. Personally I would be looking to optmise my site if I had page execution times over 1 second, but again this depends on how many users you have online at any one time, and what your site is doing. The MySQL query counter is not as important as different environments will be able to process varying amount of queries in the same amount of time. I'd still be looking to keep this under 100 if you can though.

Re: Page timer & MySQL counter

JMorris Published 08/09/2005 10:29 XOOPS is my life! Joined 04/11/2004 Comments 2722

I used the inser.showstat hack on my site when I was running 2.0.13 and it worked great. Now, with 2.2.1, it no longer works. I tried the code Mithrandir mentioned, but it does not work correctly now either.

Mith's code will display the correct execution time, but the SQL queries only show 3. I turned on MySQL debug to verify this. For instance, on my homepage, there are 64 database queries, but the script only shows 3.

What alterations to the script do I need to make to get it to display the correct MySQL query count?

Also, are their any plans of updating the insert.showstat hack for 2.2.x?

Thank you,

James

Re: Page timer & MySQL counter

Mithrandir Published 08/09/2005 11:11 XOOPS is my life! Joined 06/21/2003 Comments 6320

For XOOPS 2.2:

 <{php}> 
$querycount = 0; 
foreach ($GLOBALS['xoopsLogger']->queries as $context) { 
    $querycount += count($context); 
} 
echo round(($GLOBALS['xoopsLogger']->dumpTime()), 3)." Seconds | ".$querycount." Queries"; 
<{/php}>

Re: Page timer & MySQL counter

JMorris Published 08/09/2005 11:15 XOOPS is my life! Joined 04/11/2004 Comments 2722

Quote:

Page Load Statistics: 0.591 Seconds | 69 Queries

Works like a charm.

Thanks Mithrandir!

Re: Page timer & MySQL counter

tempel33 Published 08/29/2006 20:59 Just popping in Joined 11/05/2004 Comments 47

does not seem to work with XOOPS 2.0.14. the time may be correct but the number of queries is always 3 (using mith code for 2.2.x) or 1 (using the code for 2.0.x)

Re: Page timer & MySQL counter

SERMAS Published 09/08/2006 12:02 Just popping in Joined 09/08/2006 Comments 1

Yes, the number of inquiries shows incorrectly. Prompt please where and that it is necessary to correct. Thanks.

Re: Page timer & MySQL counter

Djiman Published 09/08/2006 14:03 Updated 09/08/2006 16:28 Just popping in Joined 07/26/2006 Comments 91

[delete]&[edit] Oops Sorry ! Mithrandir, I dd not see that you posted that same code earlier.

Re: Page timer & MySQL counter

Will_H Published 09/12/2006 22:38 Friend of XOOPS Joined 10/10/2004 Comments 1786

If you turn debug on itmatches up in 2.0.15

Anyone have any ideas?

Re: Page timer & MySQL counter

satanas Published 11/25/2006 23:35 Just popping in Joined 01/02/2005 Comments 13

Hi all,

On version 2.0.15, it's seems that the code and the values taken are done while the XOOPS kernel is still processing some queries,

The result is always 3 queries, the time value seems to be good

Is there any fixes yet?

Re: Page timer & MySQL counter

satanas Published 12/04/2006 14:53 Just popping in Joined 01/02/2005 Comments 13

A small up,

But by looking deeper in the code, it"s seems that the stats structure is only provisionned when the core is in debug mode ( Certainly for speed issues ) So I guess there are no solutions..

Login

Username

Password

Remember me

Search

Advanced Search

Donat-O-Meter

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}

{{ record.commit.author.name }} {{ record.commit.author.date | formatDate }}

Hacks: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Re: Page timer & MySQL counter

Login

Search

Recent Comments

Re: New Admin Theme for XOOPS (Beta)

Sanford Pharmacy: Exceptional Pharmacy Services Tailored to You

Re: New Admin Theme for XOOPS (Beta)

Re: XOOPS 2.5.12 Beta-2 available for Testing

Re: XOOPS 2.5.12 Beta-2 available for Testing

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}

Archives

News archives