• 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
    • Book and Chapter Pages are Slow

    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: Book and Chapter Pages are Slow

    • Issue Tools
      • View Changes
    1. issueid=1599 May 25, 2010 12:59 PM
      pegasus pegasus is offline
      VaultWiki Team
      Book and Chapter Pages are Slow

      When viewing a Book's TOC or any of its chapters, the entire chapter-list is loaded for the highest level book in the hierarchy, even if only a subset is needed. Depending on the size of the entire book, this can be a rather large query, and the way the chapter order for nested books is determined is somewhat inefficient.

      Since we already have to create a dedicated book table for subscriptions, it's even more practical than before to include pre-generated parentlists and childlists. May be able to eliminate top_bookid once we make this change.

      Also adding a previd and nextid to the chapter table could make the previous/next links much faster to generate.
    Issue Details
    Issue Number 1599
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Performance
    Status Fixed
    Priority 3 - Loss of Functionality
    Affected Version 3.0.0 RC 3
    Fixed Version 3.0.0
    Milestone VaultWiki 3.0.0
    Software DependencyAny
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. May 31, 2010 12:28 AM
      pegasus pegasus is offline
      VaultWiki Team
      Changed this behavior for the next build. It wasn't necessary to add previd and nextid columns, since this information is easy enough to gather from the parentlist > childlist field when there are no more siblings.

      These changes, while it was enough to make my head explode figuring out how it would work (much like top_bookid did originally), mean that the majority of the work constructing the TOC is done when adding or updating chapters, and the parentlists and childlists fetched on runtime. On deeply nested books (such as child-books of the VaultWiki Manual), I noted some improvements of ~0.1 seconds. On complex books that contain deep nests (such as the manual itself), if there was any improvement it was likely only due to removing a number of loops that took ~0.02 seconds.

      Developers should note that as of 3.0.0 Final, the top_bookid field was dropped in favor of parentlist.
      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 6:27 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.