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....

jeffj · #82 12-28-2002, 11:29 AM

most excellent... I had it up and running on my test site in about 5 minutes...and it worked great!

then I moved index.php to my production site... and ....too bad I forgot to add the cache table to my production site....but that only took about 10 seconds and I beat everyone before they saw the mysql error that I did...

it works great and I love it!

- jeff

Xenon · #83 12-28-2002, 08:21 PM

thanks for the kind words

i found out it works nearly perfect, just a small thing i had to change before it will be moved into full releases

i think it will be there before next year

freeshares1 · #84 12-28-2002, 09:08 PM

:clicks on install:

It works very well and i have noticed that my forum home loads a lot quicker.

DrkFusion · #85 12-29-2002, 03:29 AM

One for forumdispay and showthread would be really nice

This is the next best thing to microstats

Thanks to Xenon my forumhome:
Page generated in 0.09714496 seconds (75.75% PHP - 24.25% MySQL) with 13 queries.

fury · #86 12-29-2002, 03:33 AM

Great hack! It = teh winnar. I now get 0.2-0.3 second forumhome generation times, with 18 queries if cached, 25 if not.

Since I have the persistent mark forums read hack by ethank installed I had to modify part of that in member.php to be able to get forum lights to turn off, but other than that, it looks to be working perfectly.

fury · #87 12-29-2002, 03:37 AM

One for showthread would be HUGE

fury · #88 12-29-2002, 11:24 PM

I noticed after installing this hack, total post count is off by 10... there are 111979 post records in the database but the sum of the replycount column is 111989.. there are 10 extra posts somehow (10 is how many forums I have which have posts in them, but I don't know why this would have any effect)

Running the counters again didn't help.

X-Fan · #89 12-30-2002, 12:54 AM

Just installed this, and it works great! My forum home page went from around 32 queries down to 19!

I'm wondering if there's any way to add this to vbHome for those (like me) who use that as their site's portal page?

DrkFusion · #90 12-30-2002, 02:20 AM

Vote Xenon for vB Dev :-p

This is a great method, I would love this for the all of vb

Xenon · #91 12-30-2002, 10:17 AM

*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...

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04838 seconds Memory Usage 2,291KB Queries Executed 25 (?)
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 (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 (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)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!