vb.org Archive

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)

Erwin 07-17-2002 06:14 AM

Make sure you include all your templates in the PHP file's templatesused=" " section. Each template called not in that section is one extra query.

Do a search for the word "query" in the file and then remove all queries that you can make do without. For example, I disabled invisibility, which means I can remove the queries for people browsing a forum etc. - it all adds up.

X-Fan 07-17-2002 06:48 AM

I did that for my forums/index.php and it only reduced the number of queries by two.

Boofo 07-17-2002 07:07 AM

How fo you tie those 3 queries together? Mind giving us the code to do it? :)

Quote:

Originally posted by Nakkid
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.


Boofo 07-17-2002 07:09 AM

What about the templates that don't always get used unless you link to it? Will including them hurt at all?

Quote:

Originally posted by Erwin
Make sure you include all your templates in the PHP file's templatesused=" " section. Each template called not in that section is one extra query.

Do a search for the word "query" in the file and then remove all queries that you can make do without. For example, I disabled invisibility, which means I can remove the queries for people browsing a forum etc. - it all adds up.


TECK 07-17-2002 08:18 AM

Quote:

Originally posted by Erwin
My showthread has 18 queries - that is the bare minimum I can get it down to, without removing hacks I want.
is impossible. a showthread have 22 queries. unless you removed certain functions, you cant have 18queries. and your hacks you have installed dont perform any queries.
a showthread have 18-19queries when is an empty thread (no threads posted in the last 30days). as soon as you post once, it pops to 22.

firefly (who i'm pretty sure he started slowly to implement on this board vb3 code technique) have it at 29queries.

TECK 07-17-2002 08:27 AM

Quote:

Originally posted by Boofo
How fo you tie those 3 queries together? Mind giving us the code to do it? :)

search the board. it was posted. or open a new thread in general hacking discussion.

Boofo 07-17-2002 08:59 AM

I figured I'd get that answer from you. I just wanted to make sure you would react that way. You've proven yourself once again, my friend. Some things never change :)

TECK 07-17-2002 09:09 AM

did you noticed that nobody is answering you related to your 'deviated from thread' questions? in any post? why do you think we have several forums here?
firefly, i have an idea: delete all the forums and make only one ok? "full releases".

and yes, i dont forget when someone is calling me a liar in public.

Boofo 07-17-2002 09:17 AM

Why don't you calm down, there, son? We all know how you get when you don't get your nap. :)

As far as being not on topic goes, if I remeber right, you brought it up in the first place when you basically called Erwin a liar.

And as far as you being called a liar, that was never actually said in the thread. But, then, you proved yourself when you added the fix from Neo to the file and kept the old version number on it. Do it once, do it again? :)

Firefly, did you catch that? He had an idea! Was it an original one, or someone else's rehash. Just curious. :)

Quote:

Originally posted by Nakkid
did you noticed that nobody is answering you related to your 'deviated from thread' questions? why do you think we have several forums here?
firefly, i have an idea: delete all the forums and make only one ok? "full releases".

and yes, i dont forget when someone is calling me a liar in public.


TECK 07-17-2002 09:21 AM

you make me smile when you call me son.
the discussion with erwin was not off topic because it didnt involved any extra hacking that does interfere with this hack. it's simple information related to users experience with the hack, since they are able to actually see the number of queries performed.

your request involved a different hack that have nothing to do with vbmicrostats.
as far as our personal issues, is off topic from this hack. if you have any issues, open a new thread or use pm or email.


All times are GMT. The time now is 02:31 PM.

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.01506 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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