phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Page generation time more statistics like here


 
Search this topic... | Search MOD Requests... | Search Box
Register or Login to Post    Index » MOD Requests  Previous TopicPrint TopicNext Topic
Author Message
qspy
Board Member



Joined: 03 Nov 2009

Posts: 10



PostPosted: Tue Nov 03, 2009 7:01 pm 
Post subject: Page generation time more statistics like here

Hello,
Same people from tweaks for large forums icon_wink.gif finally got here.

I want ask for this mod which is in footer here:
Quote:
Generated in 0.0211 seconds using 10 queries. (SQL 0.0027 Parse 0.0009 Other 0.0175)


It would help to know how much is parsing taking and how much in whole time takin sql. BTW what is this "other"? Is this calculations very accurate?

Regards
Back to top
Dog Cow
Board Member



Joined: 18 Nov 2008

Posts: 378


flag
PostPosted: Wed Nov 04, 2009 1:32 pm 
Post subject: Re: Page generation time more statistics like here

qspy wrote:
BTW what is this "other"? Is this calculations very accurate?
If I understand correctly, it's the result of a subtraction operation.


... And here's the article which explains it: http://www.phpbbdoctor.com/blog/2008/02/29/timing-queries-in-phpbb2/

I did remember correctly.

_________________
Moof!
Lincoln's Tomb, Oak Ridge Cemetery, Springfield ILMac 512K BlogMac GUI
Back to top
qspy
Board Member



Joined: 03 Nov 2009

Posts: 10



PostPosted: Wed Nov 04, 2009 9:37 pm 
Post subject: Re: Page generation time more statistics like here

OMG OMG OMG OMG icon_biggrin.gif OMG !!!!!!!!!!!!!!!!
LOVE U drathbun, huge mod icon_biggrin.gif finally, thanks to this mod i was able to track and decrease viewtopic page ( most accessed ) generation time by up to 50% icon_smile.gif


// BEFORE (with my own posts cenzorship mod)
overall: 0.1250 (sql: 0.0167 php: 0.0008 other: 0.1075)
overall: 0.1251 (sql: 0.0163 php: 0.0010 other: 0.1079)
overall: 0.1349 (sql: 0.0216 php: 0.0008 other: 0.1125)
overall: 0.1465 (sql: 0.0155 php: 0.0026 other: 0.1285)

// AFTER (without my own posts cenzorship mod)
overall: 0.0645 (sql: 0.0174 php: 0.0008 other: 0.0463)
overall: 0.0618 (sql: 0.0143 php: 0.0008 other: 0.0466)
overall: 0.0608 (sql: 0.0144 php: 0.0007 other: 0.0457)
overall: 0.0645 (sql: 0.0178 php: 0.0008 other: 0.0459)

(legend: php means pparse template functions time, other means processing time of every other PHP code (excluding template parsing and SQL)).

OMG icon_biggrin.gif 2 times faster !!!!! If 200 concurrent request are made like every day i will save 120 seconds of parsing time : D, hope for a lot CPU lower usage today. My CPU was hurt a lot lately (load around 11.0), now hope for big performance gain icon_smile.gif.

PS
Thanks Dog Cow for link icon_smile.gif

PS2
Must change my way of censorshipping, from dynamic to static (not in viewtopic but before insert/update to DB). Dynamic only defaced hundreds of linked external images for example.

PS3
This is amazing, never thought php taking most of page generation time. Always thinking it was SQL.
Back to top
dogs and things
Board Member



Joined: 18 Nov 2008

Posts: 628
Location: Spain


flag
PostPosted: Thu Nov 05, 2009 6:57 am 
Post subject: Re: Page generation time more statistics like here

Sounds interesting,

But, after reading the two related articles I don´t know what to place where. icon_redface.gif

Is there anybody willing to write this up as a MOD?

_________________
phpBB2 will never die, I hope!
Back to top
Display posts from previous:   
Register or Login to Post    Index » MOD Requests  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 4 Hours
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0380 seconds using 17 queries. (SQL 0.0082 Parse 0.0006 Other 0.0292)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo