"Check Thread Subscription" - Query

[telc]

Can someone show me where I can find this query, I am trying to determine how much of a performance impact it will have on a very large forum.

Thanks

[Jake Bunce]

What query exactly? You don't normally query thread subscriptions because those are strictly user preference.

[telc]

What query exactly? You don't normally query thread subscriptions because those are strictly user preference.

I would like to know what extra queries are run when this is enabled in admincp:

Check Thread Subscription [Yes] [No]

If enabled, this option will notify the user that they are subscribed to a thread by displaying a small icon when viewing forumdisplay and search results. It will also change the "Subscribe to this thread" text on showthread to "Unsubscribe from this thread". This can have an effect on performance.

[Jake Bunce]

I had a quick look at the code but I can't find the exact query. If no one else here is able to help you then I recommend you post on www.vbulletin.org for help with the code.

[telc]

I had a quick look at the code but I can't find the exact query. If no one else here is able to help you then I recommend you post on www.vbulletin.org for help with the code.

Thanks for looking into it for me.

[Lats]

forumdisplay.php, around line 815...

...
  FROM " . TABLE_PREFIX . "thread AS thread
   $deljoin
   " . (($vbulletin->options['threadsubscribed'] AND $vbulletin->userinfo['userid']) ?  " LEFT JOIN " . TABLE_PREFIX . "subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = " . $vbulletin->userinfo['userid'] . " AND canview = 1)" : "") . "
   " . (($vbulletin->options['threadmarking'] AND $vbulletin->userinfo['userid']) ? " LEFT JOIN " . TABLE_PREFIX . "threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = " . $vbulletin->userinfo['userid'] . ")" : "") . "
   $previewjoin
   $tachyjoin
... 

[Freddie Bingham]

It is a join on a 2 column index so it shouldn't actually add much.

[telc]

I am trying to figure out why the load average is so much higher after: 3.5.1 to 3.6.2

It would get so high at times it the site would barely load, I never had this issue in 3.5.1. All tables were optimized and repaired after the 3.6.2 upgrade.

The only new features enabled in 3.6.2 are Reputation and Infractions.

Last night I disabled "Check Thread Subscription" and so far it seems better, if it makes it though tonight with out slowing down, then I think this is the issue in 3.6.2.

Sunday is where the upgrade was done, you can see the load is much higher.

[Jake Bunce]

I have seen it suggested that a repair / optimize helps performance after an upgrade. You might try that.

[telc]

I tried that, as stated in the previous post.

"All tables were optimized and repaired after the 3.6.2 upgrade."

[Steve Machol]

Assuming you have no hacks or plugins installed all I can ssuggest is seeing this thread for help with optimizing your server:

http://www.vbulletin.com/forum/showthread.php?threadid=70117

Then post the requested info in a new thread in that forum.