• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
    • Wiki
    • Support
      • Manage Subscriptions
      • FAQ
      • Support For
        • VaultWiki 4.x Series
        • VaultWiki.org Site
    • What's New?
    • Buy Now
    • Manual
    • 
    • Support
    • VaultWiki 3.x Series
    • Bug
    • Big impact on server performance after upgrade to vB4.1.12

    1. Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

      VaultWiki allows your existing forum users to collaborate on creating and managing a site's content pages. VaultWiki is a fully-featured and fully-supported wiki solution for vBulletin and XenForo.

      The VaultWiki Team encourages you to join our community of forum administrators and check out VaultWiki for yourself.

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

    • Issue Tools
      • View Changes
    1. issueid=2663 April 21, 2012 3:39 PM
      Alan_SP Alan_SP is offline
      Regular Member
      Big impact on server performance after upgrade to vB4.1.12
      After upgrade to vB4.1.12 there's a big impact on server performance, noticed on FORUMHOME, page creation time is one second longer

      First, what I did. I upgraded my vB to 4.1.12 from 4.1.2.

      After that I noticed that page generation time is significantly longer, from about 1s to 2s (about 100% longer). It's almost all in php, not mysql (checked with debug mode). I started thread on vBcom https://www.vbulletin.com/forum/show...on-s-50-100-up

      Now I discovered that if I turn VW off, page generation time is back to normal.

      It's on FORUMHOME.

      After that I tried with latest VW (3.0.17), didn't helped. So, it's still something that causes php to work additional second. I don't know how much impact it has on other pages, but my server load is higher overall.
    Issue Details
    Issue Number 2663
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Performance
    Status Fixed
    Priority 4 - Warnings / Script Errors
    Affected Version 3.0.17
    Fixed Version (none)
    Milestone (none)
    Software DependencyvBulletin 4.x w/ ckEditor
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. April 22, 2012 12:47 AM
      pegasus pegasus is offline
      VaultWiki Team
      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.
      Reply Reply  
    2. April 22, 2012 2:13 AM
      pegasus pegasus is offline
      VaultWiki Team
      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.
      Reply Reply  
    3. April 22, 2012 2:20 AM
      Alan_SP Alan_SP is offline
      Regular Member
      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
      Reply Reply  
    4. April 22, 2012 2:45 AM
      pegasus pegasus is offline
      VaultWiki Team
      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.
      Reply Reply  
    5. April 22, 2012 2:48 AM
      Alan_SP Alan_SP is offline
      Regular Member
      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).
      Reply Reply  
    6. April 22, 2012 3:18 AM
      pegasus pegasus is offline
      VaultWiki Team
      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.
      Reply Reply  
    7. April 22, 2012 3:30 AM
      pegasus pegasus is offline
      VaultWiki Team
      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.
      Reply Reply  
    8. April 22, 2012 3:32 AM
      Alan_SP Alan_SP is offline
      Regular Member
      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.
      Reply Reply  
    9. April 22, 2012 3:35 AM
      pegasus pegasus is offline
      VaultWiki Team
      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:
      Code:
      ALTER TABLE user
      ADD INDEX timespentonline (timespentonline)
      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).
      Reply Reply  
    10. April 22, 2012 3:43 AM
      Alan_SP Alan_SP is offline
      Regular Member
      I'll report this to mod's author.
      Reply Reply  
    11. April 23, 2012 1:22 AM
      pegasus pegasus is offline
      VaultWiki Team
      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.
      Reply Reply  
    12. April 23, 2012 5:40 AM
      Alan_SP Alan_SP is offline
      Regular Member
      Yes, I always write down what I do. It's much easier to remember.
      Reply Reply  
    + Reply

    Assigned Users
    Loading Please Wait
    Tags
    Loading Please Wait
    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    All times are GMT -4. The time now is 12:12 AM.
    This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Learn more… Accept Remind me later
  • striker
    Powered by vBulletin® Version 4.2.5 Beta 2
    Copyright © 2023 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
    Copyright © 2008 - 2013 VaultWiki Team, Cracked Egg Studios, LLC.