vb.org Archive
Page 30 of 95 « First 202829 30 31324080 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   vbMicroStats: page load time, queries, GZIP and PHP version (https://vborg.vbsupport.ru/showthread.php?t=35811)

b-b00gie 05-01-2002 02:29 AM
Quote:
Originally posted by nakkid
firefly, i noticed something related to your code addon for this hack. in your site, the PHP % is always smaller then the MySQL %.
the normal way is: your PHP value should always be bigger then the MySQL one (like it's supposed to be in EXPLAIN=1). everyone's page does that, except here at vB.org. just letting you know. if i'm wrong, correct me please.

Mine does the same thing. Take a look for yourself http://www.g20.net/forum reload as much as you wish.


My average is about .30 seconds to generate the page and 35% PHP and 65% SQL.


I think it may be because I have a dedicated mySQL server, its not on the localhost. :squareeyed:

b-b00gie 05-01-2002 02:37 AM
Also, I looked at my $adminstats and on average I see something like...

Page generated in 0.26241195201874 seconds with 22 queries,
spending 0.18734097480774 doing MySQL queries and 0.075070977210999 doing PHP things.

The SQL is taking longer to generate than PHP. Again, most likely because my VB is connecting to a db on a seperate machine. Although it is still rather fast. :classic:

TECK 05-01-2002 02:50 AM
probably that's the case... :)
thanks for the info. i was just curious.
however, if i do this here, at vB.org (the EXPLAIN=1) it's telling me the viceversa, what is listed in %, at the bottom of the page.

Thomas P 05-04-2002 12:44 PM
New db_mysql.php released:
http://www.vbulletin.com/forum/showt...threadid=45395

TECK 05-04-2002 06:21 PM
i will change the file when VB226 will be oficially released. (today)

JoshFink 05-04-2002 07:55 PM
I like this hack. Just out of curiousity, what is an "Ideal" number to get for PHP and MySql and how do they relate?

Boy was that vague.. :D

Thanks for the help,

Josh

TECK 05-04-2002 07:57 PM
it depends on your server. there are no ideal numbers. hope that helps.

regards,
nakkid.

Jawelin 05-04-2002 09:19 PM
Quote:
Originally posted by nakkid
it depends on your server. there are no ideal numbers. hope that helps.
Sorry, Nakkid. Many posts before, you talked about the number 40 as the maximum acceptable for queries on forumhome... (apart of VBPortal... w/ more than hundred...)

I have many hacks installed involving the first page, and now I'm round 43-45... And i'm working to something else... more! :cheeky:

Btw I still have numbers like:
Code:
Page generated in 0.65888 seconds
(34.21% PHP v4.1.2 + 65.79% MySQL v3.23.45)
with 43 queries. GZip level 1. [details]
wich seem acceptable to me...

Actually, is there any reason for the limit under 40 ? Shall I be afraid of arriving till 50 ? :confused:
Thanks a lot.
Bye

TECK 05-04-2002 10:00 PM
i probably understood wrong the question. i thought he was referring at the %. :)
well, if i understood corectly from firefly, the more queries you have, the higher your server load will be. eventually, on a busy board it will bring the server to it's knees and your host will cancel your account. there are alot of people out there who have 150queries on a page, without even knowing.

so i set myself a goal not to have more then 40queries on a page. even 40, on a very busy board, is dangerously high. i'm talking about boards with 300-400 users online that activly post every second. if you have 50queries, that will kill your server, if not even crashing it.

the highest value will be arround 34queries, on my site. and that's the main page (vbHome full version).

Thomas P 05-04-2002 10:00 PM
Quote:
Originally posted by nakkid
i will change the file when VB226 will be oficially released. (today)
Thanks :)
-Tom


All times are GMT. The time now is 02:31 PM.
Page 30 of 95 « First 202829 30 31324080 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01505 seconds
  • Memory Usage 1,740KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete