vb.org Archive - Board Optimization - Remove unnecessary queries from search results pages

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Board Optimization - Remove unnecessary queries from search results pages (https://vborg.vbsupport.ru/showthread.php?t=252613)

Andreas

10-25-2010 10:00 PM

Remove unnecessary queries from search results pages

1 Attachment(s)

Subject says it all ;)

This is basically a workaround for VBIV-9907

Note
If you are using custom code/Add-ons to display avatars on search results pages this Add-on might cause side-effects.

MoMan

10-26-2010 05:17 PM

Not applicable to vB3, I'm assuming?

Brandon Sheley

10-26-2010 05:21 PM

Quote:

Originally Posted by MoMan (Post 2114525)

Not applicable to vB3, I'm assuming?

vB Version: 4.0.8 ;)

cad2go

10-27-2010 06:22 AM

tagged!

MoMan

10-27-2010 01:42 PM

Quote:

Originally Posted by Loco.M (Post 2114529)

vB Version: 4.0.8 ;)

Right, this mod is for 4.0.8, but my question was asking whether or not such a redundancy might also exist in vB3 (doesn't sound like it).

abdobasha2004

10-29-2010 01:07 PM

this is nice
i like all mods that make forum run fast and reduce server load in any way

Boofo

10-29-2010 02:01 PM

This will also work on 4.0.6/4.0.7 as the same code is in those, too.

sticky

10-29-2010 03:52 PM

Quote:

Originally Posted by Boofo (Post 2115674)

This will also work on 4.0.6/4.0.7 as the same code is in those, too.

What about 4.0.2?

Boofo

10-29-2010 04:14 PM

I have no idea as I only have 4.0.6 running myself, but did check 4.0.7, too.

Andreas

10-29-2010 04:20 PM

Quote:

Originally Posted by sticky (Post 2115710)

What about 4.0.2?

Not applicable, the code that causes the unnecessary queries was introduced in 4.0.4

BadgerDog

10-29-2010 04:34 PM

Quote:

Originally Posted by Andreas (Post 2115720)

Not applicable, the code that causes the unnecessary queries was introduced in 4.0.4

I'm using 4.04pl1, so this would work for me?

Regards,
Badger

Andreas

10-29-2010 05:28 PM

Sorry but I don't know - try it out :)

BadgerDog

10-29-2010 06:38 PM

Quote:

Originally Posted by Andreas (Post 2115748)

Sorry but I don't know - try it out :)

Ok, I installed it and ran a search ... :)

Nothing blew up, but quite frankly, I'm not sure what I'm supposed to be seeing as a difference, if anything as I don't know what to specifically test. :D

Regards,
Badger

Boofo

10-29-2010 06:49 PM

You will see less queries run for searches.

dawges

10-29-2010 08:03 PM

Thank you. Very nice.

final kaoss

12-31-2010 04:42 PM

looks like it's scheduled to be fixed in 4.2

Boofo

12-31-2010 04:43 PM

Quote:

Originally Posted by extreme-gaming (Post 2141914)

looks like it's scheduled to be fixed in 4.2

Until they break in again in a future version.

OldSchoolDSL

12-31-2010 04:52 PM

I'm still using this in 4.1 PL2

No errors, no problems

AusPhotography

01-13-2011 01:33 AM

V4.1.0 and V4.1.1 diff files posted by me (Ricktas on vb.com)

Andreas

01-13-2011 09:30 AM

<a href="http://tracker.vbulletin.com/browse/VBIV-9878" target="_blank">http://tracker.vbulletin.com/browse/VBIV-9878</a>
The patch adresses a lot more issues than just thise one and significantly reduces the amout of queries for searches.

mark99

03-16-2011 09:41 AM

Can we just download the .XML and apply this on 4.1.2 or do we have to still use the manual diff file method?

OldSchoolDSL

12-03-2011 06:13 AM

Un-installed.

4.1.8 fixes everything that this modification resolved.

But I would like to thank the developer for having this out 1 year before vBulletin patched it. :)

Hippy

06-03-2012 12:13 PM

Quote:

Originally Posted by OldSchoolDSL (Post 2274238)

Un-installed.

4.1.8 fixes everything that this modification resolved.

But I would like to thank the developer for having this out 1 year before vBulletin patched it. :)

dido.. thanks Andreas

All times are GMT. The time now is 02:56 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01125 seconds Memory Usage 1,751KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (23)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: