PDA

View Full Version : Board Optimization - Remove unnecessary queries from search results pages

Andreas
10-25-2010, 10:00 PM
Subject says it all ;)

This is basically a workaround for VBIV-9907 (http://tracker.vbulletin.com/browse/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
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
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
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
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
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
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
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
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