The Arcive of Official vBulletin Modifications Site.

joeychgo · #11 05-07-2004, 09:24 PM

I have these hacks
Ad Columns

Who was online today

Arrange Sub-Forums in columns

Dynamic Announcements

Those are the ones that affect my forum home:
(Page generated in 0.15843 seconds with 15 queries (2 queries for uncached templates) [Server Loads: 0.55 0.94 : 1.10])

On my VBA page I have

Weather Block

Dynamic Announcements

Page generated in 0.18439 seconds with 19 queries (2 queries for uncached templates) [Server Loads: 0.93 0.96 : 1.09]

My vb garage has Ad Columns
Page generated in 0.11596 seconds with 36 queries (3 queries for uncached templates) [Server Loads: 1.04 1.10 : 1.12]

My Timeslips page has Ad Columns
Page generated in 0.08468 seconds with 10 queries (2 queries for uncached templates) [Server Loads: 1.09 1.10 : 1.12]

My Links and Files database has Ad Columns
Page generated in 0.19688 seconds with 14 queries (2 queries for uncached templates) [Server Loads: 0.90 1.07 : 1.11]

Thats all of it

EvilLS1 · #12 05-07-2004, 10:23 PM

I see a couple in the vbgarage hack.

In vbgarage.php find:

Code:

	'vbgarage_popup',
	'vbgarage_viewgarage'

Replace it with:

Code:

	'vbgarage_popup',
	'vbgarage_commentbits',
	'vbgarage_latestbits',
	'vbgarage_viewgarage'

Looks like Ad Columns is shown on most of your other pages so its probably causing the others.

In global.php find:

Code:

	// misc useful
	'spacer_open',

Replace it with:

Code:

	// misc useful
	'spacer_open',
	'adcolumn_left',
	'adcolumn_right',

See if that takes care of the uncached templates.

joeychgo · #13 05-07-2004, 11:09 PM

VBA

Before Changes: Page generated in 0.26726 seconds with 19 queries (2 queries for uncached templates) [Server Loads: 0.44 0.84 : 1.09]

After Changes: Page generated in 0.27118 seconds with 17 queries [Server Loads: 0.76 0.90 : 1.08]

Forum Home

Before Changes: Page generated in 0.27529 seconds with 15 queries (2 queries for uncached templates) [Server Loads: 1.52 1.06 : 1.15]

After changes: Page generated in 0.16029 seconds with 13 queries [Server Loads: 0.69 0.91 : 1.09]

VbGarage

Before changes: Page generated in 0.15391 seconds with 34 queries (1 queries for uncached templates) [Server Loads: 1.43 1.03 : 1.10]

After Changes: Page generated in 0.11484 seconds with 33 queries [Server Loads: 0.83 0.94 : 1.06]

Yes, it took care of the uncashed templates, thanks --- my queries still look high to me??? How do I fix that?

EvilLS1 · #14 05-07-2004, 11:32 PM

Your vbGarage page has alot of queries. The others are fine. Have you added anything to the vbgarage hack? I have it installed on my test forum and for me it shows less than 12 queries.

joeychgo · #15 05-08-2004, 12:43 AM

Nope - the VbGarage is self contained - only has the adcolumns hack.......

Could it be something about how many garages I have stored there? My timeslips (which also only has the adcolumns hack) has 8 queries --- my vbgarage has 33 with 25 garages per page -- 25+8=33

its probably not that simple -- but its a thought?

EvilLS1 · #16 05-08-2004, 12:59 AM

Your Timeslip Database page has no effect on the # of queries in your vbgarage. Its a separate script. Maybe the vbgarage adds a query per every user shown on the main list. I haven't really looked at it yet.

joeychgo · #17 05-08-2004, 01:08 AM

thats kind of what I was thinking, cause the timeslip and vb garage have the same hacks so I was comparing one to the other -- and the numbers add up........

lifesourcerec · #18 05-09-2004, 10:02 AM

that fixed my uncached probably also but server load a little high:

Page generated in 0.36117 seconds with 14 queries [Server Loads: 6.76 5.54 : 5.80]

And this is with only me on it. Server name hasn't switched over yet.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04069 seconds Memory Usage 2,252KB Queries Executed 12 (?)
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 (4)bbcode_code (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 (8)post_thanks_box (8)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (8)post_thanks_postbit_info (8)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!