The Arcive of Official vBulletin Modifications Site.

Optimizing Forumhome · **Released**: 12-19-2002

Ok, what this Hack does is it reduces the ammount of queries on forumhome by caching the moderatorlist and by optimizing most of the queries used on index.php

I'd really appreciate getting feedback how it reduces serverload on greater boards

On an unhacked vb index.php (pm enabled accesmask disabled) it reduces the ammount of queries from 19 to 15
my experiments have shown, that the queries are faster than the normal ones, too....

Xenon · #92 12-30-2002, 11:33 AM

Ok, uploaded a little modified file now
Moved the thread to Full Releases

thanks to all who helped me in the betaphase

NuclioN · #93 12-30-2002, 11:45 AM

i get a gzinflate parse error at the top of the forum index after replacing the old code with the new. (?)

Dean C · #94 12-30-2002, 12:45 PM

Awesome i'll try this on my localhost tonite

Xenon · #95 12-30-2002, 01:43 PM

@NuclioN: How old was your last version?
the last update justs changes a small if-clause nothing with the gzinflate function...

as a tip, just empty the whole forumcache table and it should work again

Dean C · #96 12-30-2002, 09:16 PM

Wow this works wonders Xenon..

Reduced my testboard from 19queries to 14queries when dont on a fresh install

- miSt

Smoothie · #97 12-31-2002, 01:34 AM

How well does this work with hacks that are installed?

Boofo · #98 12-31-2002, 01:43 AM

There's some that won't work very well (or at all) with it, that is why I had to un-install it. Great idea, though.

Smoothie · #99 12-31-2002, 03:01 AM

thats a shame.

Dean C · #**100** 12-31-2002, 09:05 AM

Yep well i'm sure there's a way around it and Xenon will guid you all the way

Xenon · #**101** 12-31-2002, 12:53 PM

@Smoothie: it depends on the hack, subforums on forumhome for example works perfect and has a huge effect on reducing queries.

if you are a little experience you can nearly make every hack to work with it.

but it doesn't work with this hack:
# of users browsing on Forumhome

Chris M · #**102** 12-31-2002, 01:15 PM

Hmm...

I can't remember if I have that one installed

*damned script kiddies attacking my Hosts server

*

I will test it out on DB when it gets back up

Satan

Xenon · #**103** 12-31-2002, 01:24 PM

you'll like it chris

Chris M · #**104** 12-31-2002, 01:35 PM

Hehe no doubt

It will probably reduce my Forumhome queries considerably - At last check, I think I had 24 or 26

Satan

Smoothie · #**105** 12-31-2002, 04:09 PM

Quote:

Originally posted by Xenon
@Smoothie: it depends on the hack, subforums on forumhome for example works perfect and has a huge effect on reducing queries.

if you are a little experience you can nearly make every hack to work with it.

but it doesn't work with this hack:
# of users browsing on Forumhome

Don't have that one installed, but I do have a hack for Photo Post installed.

fury · #**106** 01-01-2003, 01:27 PM

Quote:

Originally posted by Xenon
*ggg* thx Arunan

@X-Fan: When i have more time and completly finished this beta, i will work with TECK on an inclusion into vBhom (lite)

@fury: There are two possibilities:
1. your counters are wrong (update your counters, be sure you'll do in the right order (first threads then forums)
2. you have orphan posts which don't appear in any threads...

My counters were already updated like a billion times. Doing the orphan posts option didn't find anything either.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05963 seconds Memory Usage 2,355KB Queries Executed 30 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (16)post_thanks_box (16)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (16)post_thanks_postbit_info (15)postbit (16)postbit_onlinestatus (16)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!