The Arcive of Official vBulletin Modifications Site.

N9ne · #1 10-22-2002, 07:50 PM

This should reduce queries, maybe make forumhome faster, less server load...etc.?

How can I do this then...

NTLDR · #2 10-22-2002, 07:55 PM

If you mean the post/thread counts then I'm not sure if you can do the counts from 2 different tables in one query.

N9ne · #3 10-22-2002, 07:57 PM

I mean at the top, Members: 5000, Threads: 6000, Posts: 525252

That part ???

NTLDR · #4 10-22-2002, 08:02 PM

I doubt that it can be done and if it can I expect its less load on the server to do it the way it is now.

N9ne · #5 10-22-2002, 08:14 PM

ok thanks

N9ne · #6 10-22-2002, 08:14 PM

Do you have any other techniques of reducing queries on forumhome, forumdisplay, showthread?

Logician · #7 10-23-2002, 09:40 AM

If you are patient enough to go through the entire vb structure and hack some parts accordingly, here is a thought:

Instead of querying the database online when that info is needed, save this info in a seperate record alltogether and query that field only when needed. Let me clarify:

Your main page querys your db for member count, post count and thread count each for one, 3 in total. If you update a table field with this info everytime membercount/postcount/thread count changes, you can just query that field and get all 3 info at once with a single query. But of course you need to hack vb so that everytime this numbers changes, your record is updated.

This method applies to all queries in you main page. If you go to extremes, you can make it so that your forum home query is 1 in total, getting the entire page as a HTML code with one signle query, provided that you can manage to update that code everytime an incident that changes your main page happens. Well this is of course way too radical, but I just wanted to demonstrate the idea..

You can check the buddy and ignore columns in user table for a "live demonstration". It's only one field so the data is get with 1 query, but they save more than 1 records in it.

N9ne · #8 10-23-2002, 03:02 PM

Would functions.php be the file to edit to do the above you said, ie. combining those three queries?

Xenon · #9 10-23-2002, 04:01 PM

no, that's what he meant, you have to change more than just one file...

you have to change register.php for the meber stuff
and editpost.php/postings.php/newreply.php/newthread.php for post / thread stuff

everytime you add/delete a post you have to change the posts-value in the db....

N9ne · #10 10-23-2002, 04:11 PM

I see, with my tiny knowledge of PHP, I'll stick with my queries for now

thanks for the insight though!

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03874 seconds Memory Usage 2,245KB Queries Executed 13 (?)
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)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)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_postinfo_query fetch_postinfo 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!