The Arcive of Official vBulletin Modifications Site.

Optimize forumhome, the filburt1 Way · **Released**: 05-26-2003

This hack greatly reduces the number of queries on forumhome. On my test board, before:

Code:

Page generated in 1.81393003464 seconds with 30 queries,
spending 1.17402160168 doing MySQL queries and 0.639908432961 doing PHP things.

After:

Code:

Page generated in 1.37496697903 seconds with 20 queries,
spending 1.00117218494 doing MySQL queries and 0.373794794083 doing PHP things.

The very, very clever hacker can combine elements of this hack and Xenon's to reduce forumhome queries even more; specifically, his optimizations for a moderator cache and Who's Online.

There's also an added benefit: since the number of rows in all tables are cached and not just users, posts, and threads, you can use $counts[tablename] anywhere in forumhome and have the number of rows in tablename show up (for example: Mail Messages: $counts[mailmessage]).

Note that because some PM processing is now given to PHP instead of MySQL, the page load time might increase. It will depend on how many PMs the current user has, among other things. However, the PM handling eliminates two queries.

Alien · #52 08-09-2003, 05:50 PM

Not a problem.. I suppose if noone can help me, I could reverse all the steps in Xenon's hack and do filburt's first if that worked for you but I would prefer not to...

filburt1? Xenon? Help!

msimplay · #53 08-09-2003, 06:09 PM

lol yeh i know what u mean i really dont like hacking files but i enjoy the results
lol i added so many hacks that my forum homepage had too many queries

so least its not too bad now

ps i like your forum very nice erm wondering wha it would be like for 56k users :P

cuz i know my forum is a bit graphic heavy aswell

MaDCaT75 · #54 08-21-2003, 09:17 PM

This hack seems to have made my moderator list dissapear :cry:

NightWalk8r · #55 10-07-2003, 10:39 PM

great hack!!!!

went from 18 to 15 queries on my index page

G/J

BTW..i install Xenon's hack after i got install this and it went down even more.....from 15 to 12

futureal · #56 10-09-2003, 03:57 AM

I have noticed that using the SHOW TABLE STATUS query in this manner produces different results for threads, posts and users that if you do it the standard way.

For example, doing:

SELECT COUNT(*) AS count FROM post;

Produces a different result for me than doing:

SHOW TABLE STATUS;

And looking at the "Rows" column.

I am curious as to why this is. Anybody know?

Fi_InCogNiTo · #57 10-17-2003, 01:08 PM

Nice ^__^

Page generated in 0.44381301 seconds (89.90% PHP - 10.10% MySQL) with 18 queries.

Was 23 queries

Set · #58 02-03-2004, 09:14 AM

Hi @ll
This modification works with version 2.3.4?

thanks

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05678 seconds Memory Usage 2,263KB Queries Executed 22 (?)
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_code (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 (2)pagenav_pagelink (8)post_thanks_box (8)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (8)post_thanks_postbit_info (7)postbit (8)postbit_onlinestatus (8)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!