CES Intelligent Dot-Threads

[thincom2000]

CES Intelligent Dot-Threads
Version: 1.0.1

Requires: CES Pre-Process Hooks v1.2.0+ (https://vborg.vbsupport.ru/showthread.php?t=143155)
Recommend: MySQL 5

What It Does:
This modifies vBulletin's behavior if the following setting is enabled on your forum.

Highlight Threads in Which User Has Posted
When this feature is enabled, a logged in user will see an 'arrow' (or whatever graphic you choose) on the folder icons (hot folders, new folders, etc.) next to the threads that they have posted in.

vBulletin normally accomplishes this by adding another query to Forumdisplay. This hack removes that query.

*** NEWS ***
3/30/2007 - v1.0.0, v1.0.1 released

Known Issues:
- none

Products to Install: 1
Plugins Included: 2
Files to Upload: 0
Files to Edit: 1
New Templates: 0
Template Edits: 0

Mod Features:
- removes 1 query from Forumdisplay

*** Changelog ***
As of Version 1.0.1:
- safer file edit

[3mr3]

Thanks mate but any screenshots??

And so where is the file that we need to import ? :)

[LisaD1]

I was wondering about the file too.

[thincom2000]

Thanks mate but any screenshots??

If you can explain to me how a screenshot will prove a query is removed, I'll be glad to make one. :p

[MaestroX]

Great stuff. I'm really glad your looking to enchance vbulletin by cutting down of query usage.

Thumbs up :)

[Comalies]

Mod without a screenshot or demo = not using it.

[thincom2000]

Um, okay... maybe if you would actually read the description of the mod you would understand why posting a screenshot or demo would be meaningless.

[fastforward]

Although this removes one query from forumdisplay, it modifies the existing query by adding an expensive outer join to the post table.

Have you compared the execution plan of the modified query with the original? Remember, MySQL versions prior to 5.0 can only use one index per query. You may find the original way with the extra query is more efficient... which is probably why Jelsoft did it that way.

[da420]

Mod without a screenshot or demo = not using it.

How would a screenshot even apply to this mod?
Haha, I love it when people don't read the thread in which they are replying to. :rolleyes:

[TTG]

kinda worrying that everyone needs a picture of something before they'll accept it.

Make a caveman drawing of something thincom2000 and then they'll all want it :)

Clicked install .. thanks for the hack thincom2000

[thincom2000]

Have you compared the execution plan of the modified query with the original? Remember, MySQL versions prior to 5.0 can only use one index per query.

In that sense it's unfortunate that I'm running 5.0. I have checked the EXPLAIN for the query and the possible keys are postid, userid, threadid. The join uses userid and threadid, so it just depends on which has fewer results, but most likely it will end up using userid, which is okay for MySQL 5.0 people, but others will have to look at their query speeds to see if this is actually an improvement.

[BigJimTheLug]

Those that ask for screenshots are probably people who are not fluent in vbulletin.com talk.

[Ziki]

I strongly suggest anyone to not use this hack!vBulletin staff though of every performance possibility and if there would be one,I think they would use it.

[thincom2000]

Although I would have to agree with you that Jelsoft did an excellent job with performance in vBulletin (compare MediaWiki), I must also say that at least running MySQL 5.0.27, having developed a number of hacks using the Pre-Process hooks...

I have tested the page on my server (your server will definitely have different results) with the hooks enabled and disabled, only running this particular hack.

Processing times at average peak performance for each has revealed the following:

disabled ~ 0.002 + enabled

With the hooks disabled, times have been known to dip (extremely rarely) to the following results:

disabled + 0.001 ~ enabled

The difference as you can see is minimal in terms of time efficiency. In terms of server load:

disabled ~ 0.50 + enabled

and there is not the rare occasion where disabled dips lower than enabled.