Issue: Big impact on server performance after upgrade to vB4.1.12

If you can PM me an admin login, I can play with the plugins and see how it affects your page generation time. I'm not seeing a noticeable change here, so it might be a combination with VaultWiki + another add-on, or VaultWiki + a different setting you're using.

Okay regarding this, I don't know why it's different now that you upgraded vBulletin, in fact it should have been pretty bad on 4.1.2 as well. The issue is the number of forums you have on forum home, it evaluates around 500 templates. VaultWiki had to use a pretty bad hook involved with the template system because vBulletin gave us no other alternatives, and starts to show after around 100 templates used on one page.

Anyway, when you upgrade VaultWiki, make sure to disable the following plugins:

• Search - Continue Fudging Content Types
• Search - Fix Result URLs

This will have the following side effects:

• Wiki search results will show as posts, won't use wiki permissions, and you won't be able to use the "Jump to Article" option.
• When inserting a Wiki Image to the editor using the Enhanced Asset Manager, it will use the ATTACH BB-Code instead of the appropriate wiki image tag.

The reason the search results are wrong is that, even with the new hooks in vBulletin 4.1.12, we still can't change content types mid-search. VaultWiki is handled by search like a second content type, but we tell the search to use the post content type instead. Without a hook to change the contenttypeid back, we can't tell the search to let VaultWiki handle the results too. Until VaultWiki is stored completely as a separate content type, these search results will be wrong while the plugin is disabled.

As for the Enhanced Asset Manager, it looks like this can be fixed for the next release by attempting something even more hackish.

PS If this post sent an instant email please let me know.

Ok, just to know for sure, I need to disable this plugins on main site and it will be ok?

About first side effect, I must say that at the moment I'm not sure how bad it is, probably not bad at all.

Second one is no problem at all, as I don't use Enhanced Asset Manager, if you maybe remember, I wanted it turned off.

And yes, it seems that this is vB thing after all, at least it looks so.

About email, I didn't received it.

EDIT: To report, after I disabled those plugins page creation time is much lower, but still a bit higher than it was before. Now it's about 1.3-1.4s

Okay, seems the template_register_var plugin isn't even supposed to be there. I already fixed this way back, and somehow the plugin reappeared.

I will look at your site again to see if there's anything else that can be done.

Could I delete it or disable it from my main site? Tell me what I need to do on my live site.

And yes, email still not coming. But, I come here minute after you posted your answer (wrote about your excellent support on vBorg and vBcom).

The other plugins that add 0.3s to forum home are:

• Forum Display - Forum Redirects
• Forum Display - SubForum Redirects

You would also need to disable another product's plugin in order to get the benefit: Advanced [YOU] in FORUMBIT (Index/Last Post) x
But there is really nothing wrong with the plugins themselves, just that there are so many forums to apply them to.

Again this is due to the sheer number of forums on your forum home page, adding about 150 eval calls when you have forumbit_display plugins. While the plugins themselves might be improved slightly, the extra time is mainly coming from the overhead of the eval statement.

You can disable these plugins or reduce the number of forums on the page. However, you would also have similar issues on forum display, if you choose to view 200 threads on one page, or on show thread, if you chose to view 200 posts per page.

There is no way around this unless vBulletin rewrites the hook system to allow for file include plugins (and templates) as a choice over evaluated plugins. It's actually not a significant change code-wise, and would be backwards compatible with old plugins. It would just need a few conditionals in the hook class and some auto-replace magic to change all existing hooks to the new format. But alas, I don't think they will, as this has been suggested for some time.

For now, on your live site, I recommend just disabling the plugins in question, just in case there are other side effects of doing so.

Ok, I must say that I'm now satisfied with achieved improvement with disabling these two plugins:

Search - Continue Fudging Content Types
Search - Fix Result URLs

I'll leave others on. Now it is big enough improvement for me.

Also, in case you care about another 0.04s, add an index to your user table. You have another mod that is querying the user table on forum home without hitting an index:
You might want to report this to that mod's author. This could start being a significant lag for forums with over 100,000 members (although personally I consider .05 for a query to be slow).

I'll report this to mod's author.

I didn't think of this before, but since you don't use VaultWiki this way, you can also disable the following plugin anyway:
Forum Display - SubForum Redirects

It's not much savings, but it's a start. I see that 10,000 evals takes 0.04s, at least on my box, so this is probably just a drop in the bucket.

Also try to remember the plugins you disable. Every time you upgrade VaultWiki, you will have to disable them again.

Yes, I always write down what I do. It's much easier to remember.