The Arcive of Official vBulletin Modifications Site.

31 Queries on forum home · **Released**: 08-09-2003

Erm is 31 queries bad for forumhome ?
i've added filberts and xenons optimisation hacks
is there anything else i can do to optimise them

i seen that Vbulletin.org only has average of 17/18 queries per page

assassingod · #2 08-09-2003, 11:40 AM

Try uninstalling unnesaccery hacks they may cause lots of queries.

jdmuniverse · #3 08-09-2003, 01:42 PM

If it doesn't load slow, I wouldn't worry about it. Mine has 30 and loads just fine.

msimplay · #4 08-09-2003, 02:15 PM

i know what u mean Jdmuniverse by thing is am worried about server load

cirisme · #5 08-09-2003, 02:26 PM

I have both Filburt's and Xenon's optimization hacks(as well as a few other things) and mine only has 21 queries.

msimplay · #6 08-09-2003, 02:34 PM

whats the few other things @ Cirisme i'd be interested to know because i want mine down too

ps thats a seriosly good shoutbox on vbhome lite where can i get it from ?

cirisme · #7 08-09-2003, 03:56 PM

Quote:

Today at 09:34 AM msimplay said this in Post #6
whats the few other things @ Cirisme i'd be interested to know because i want mine down too

They're mostly improvements to my own hacks, like the POTD and chat hacks. I also added a few things to Xenon's caching, for instance the most active thread thing that is not included by default, as well as the top posters/thread starters. Nothing big.

It's weird that you have 31 queries considering the optimization hacks you've done. Any other hacks you have installed that are not affected by those optimization hacks?

Quote:

ps thats a seriosly good shoutbox on vbhome lite where can i get it from ?

Thanks! It's basically a hacked version of TWTCommish's shoutbox for the portal shoutbox.(I just copied it to shoutbox2.php, and changed the templates it uses so it would fit in the small area, and I also deleted the stats queries since they're unnecessary)

EDIT: I just took a look at your site. It looks like you're kinda running a lightweight portal with the top 10 stats stuff. .27 seconds with 27 queries(which is what it was for me as a logged out user) isn't bad for what you've got.

msimplay · #8 08-09-2003, 04:30 PM

well its not too bad now i narrowed it down to 27after getting rid of a few hacks and replacing them with template versions plus i changed the vb3 last post hack (krakkens) for Ppns version
at one point i was at 37 queries

27 logged in 25 logged out
and thats with like nearly 100 hacks installed

taking out the search index made it extremely faster i used the mysql 4 search engine hack in the beta forum its excellent

Xenon · #9 08-10-2003, 03:37 PM

as already stated, you can reduce a lot of queries, but just if you are a good hacker

i've optimized vb.org's main page as far as possible, but just because i know the hacks it uses and tried to cache as much as possible without loosing dynamic.

But never forget: sometimes it's better to have two fast queries than one slow.

Erwin · #10 08-10-2003, 11:31 PM

On my vB3 forumhome, despite multiple hacks, I only have 9 queries. Amazing, but true.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04448 seconds Memory Usage 2,288KB Queries Executed 23 (?)
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 (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 (9)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_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!