• 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
    • Recentchanges Inaccurate Byte Diff

    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: Recentchanges Inaccurate Byte Diff

    • Issue Tools
      • View Changes
    1. issueid=418 February 19, 2009 2:47 AM
      pegasus pegasus is offline
      VaultWiki Team
      Recentchanges Inaccurate Byte Diff

      On the Recentchanges and Contributions pages, for each revision there is a +- number that gives the number of characters that were added or removed since the preceding revision. The current method of attempting to group the table rows with a lower table row is convoluted, takes multiple queries, and inefficient.

      Not only that, but for new pages, it shows the number of bytes that are different from whatever the previous revision in the database is.

      Was able to speed up these pages a bit by adding another field to the revision table (lastrevisionid). For each revision, the previous revision is linked to the row on this field. This means we can skip ordering and grouping because we have the ID, and we can avoid a second query, and avoid 2 more loops. All-in-all, this makes things more efficient and correct.

      Fixed for the next build. However, even with these changes, these queries are still slow. When compared to the vault_link table queries, I cannot see why, considering those use larger tables with less specific criteria with just as many joins.
    Issue Details
    Issue Number 418
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category History / Revisions
    Status Fixed
    Priority 4 - Warnings / Script Errors
    Affected Version 2.2.0
    Fixed Version 2.2.1
    Milestone (none)
    Software DependencyAny
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    + 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 8:02 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.