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

forumdude · #**227** 05-18-2003, 02:20 AM

When users don't have any new pms since their last visit this is what the Private Message box says:

You have new message(s) since your last visit.

where it should be:

You have 0 new message(s) since your last visit.

Anyone else notice this or have the same problem?

Also, it lists fine if there are 1 or more new pms.

Xenon · #**228** 05-18-2003, 09:37 AM

that problem normally can't occur if you have this lines in your code:

PHP Code:


			
  $unreadpm['messages'] = intval($unreadpm['messages']);

  $newpm['messages'] = intval($newpm['messages']);

edit: oops, the last line wasn't in the uploaded file, sorry

just add it to your code and it'll work

forumdude · #**229** 05-18-2003, 03:07 PM

Thank you so much.

DeeperImage · #**230** 05-22-2003, 09:14 PM

I have installed it and almost imediately the server loads dropped down to half. Is there a way for me to check how many queries are being requested by typing in some kind of command from phpmyadmin? I dont have the GZIP, Queries hack installed yet. Thanks.

xs1 · #**231** 05-23-2003, 06:06 AM

anyone tested in 2.3.0 ?

Xenon · #**232** 05-23-2003, 10:52 AM

@Deeper: you should install teck's microstatshack

@xs1: yes, it's used here on vb.org

Courage · #**233** 05-23-2003, 02:57 PM

I use this on 2.3.0 is a very good hack, but i still ahve a big problem. I need to optimize showtheread page. It has to many querries

Any ideea ?

Xenon · #**234** 05-23-2003, 03:54 PM

*gg*
yeah, rewrite the whole file ^^

i didn't found a easy way to optimize showthread.php without rewriting it a lot...

Courage · #**235** 05-23-2003, 03:57 PM

this is bad. I looked to my online visitors behavior.
I have very few on Forum Home...

Y2KevSE · #**236** 05-28-2003, 06:24 PM

Works nicely on 2.3.0!

Alien · #**237** 05-28-2003, 11:17 PM

I have this hack installed, now since I don't show the moderator column on forum home and removed it's display from the templates, is there some code here that I can get rid of to reduce a query?

-Jason

Erwin · #**238** 05-29-2003, 07:17 AM

Yes - just edit index.php and comment out or remove the query that searches for the moderators. That will save you 1 query too.

Xenon · #**239** 05-29-2003, 09:55 AM

Erwin, he has my hack installed!

@Alien: nope, when you have installed my hack the query for the mods is gone already and a cache is used, so you cannot save anything more with removing the mod col

Erwin · #**240** 05-29-2003, 11:37 AM

Oops, sorry!

I don't know anything about your hack, Xenon. LOL!

Xenon · #**241** 05-29-2003, 12:31 PM

you should look into vb.org index.php to see most of my hack

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08547 seconds Memory Usage 2,353KB 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 (1)bbcode_php (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!