• 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 4.x Series
    • Task
    • Reduce 1 Query on All Wiki Pages

    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: Reduce 1 Query on All Wiki Pages

    • Issue Tools
      • View Changes
    1. issueid=2662 April 21, 2012 4:47 AM
      pegasus pegasus is offline
      VaultWiki Team
      Reduce 1 Query on All Wiki Pages

      Before a wiki page even initializes vBulletin, there are between 2 and 3 queries to the database that vBulletin's debug mode doesn't know about because it wasn't started yet. So every wiki page load's query count is +2 for regular URLs, and +3 for custom URLs.

      If we adopt a similar system to vBSEO, we can remove 1 of those queries. Currently the first query looks up the values of several settings needed to determine if this is a valid wiki request. These values can be dynamically saved in a config file much like in vBSEO and read from the file on each request. We can improve on vBSEO's design by using a text file instead of XML, in order to reduce the amount of processing that needs to be done on the file.

      Additionally, in the case where the script detects that we are directly requesting 'wiki_index.php' exactly, we can defer all of those queries (and the config parsing) until vBulletin has started.
    Issue Details
    Issue Number 2662
    Issue Type Task
    Project VaultWiki 4.x Series
    Category General
    Status Completed
    Priority 6 - Dev-Related Tasks
    Target Version 4.0.0 Alpha 1
    Resolved Version 4.0.0 Gamma 4
    Milestone VaultWiki 4 Gamma X
    Software DependencyvBulletin 4.x
    License TypePaid
    Votes to perform 0
    Votes not to perform 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. April 21, 2012 3:14 PM
      pegasus pegasus is offline
      VaultWiki Team
      Looked at this more today, and there's more hidden queries than I initially counted that are supposed to be in the datastore...
      +1 for nodetypes
      +1 for URL replacements
      +1 for prefixes

      These need to be combined somehow even before Alpha 2 and fetch from the datastore even though it's unavailable.
      Reply Reply  
    2. April 21, 2012 4:15 PM
      pegasus pegasus is offline
      VaultWiki Team
      Combined nodetypes, replacements, and prefixes to one query.
      Reply Reply  
    3. March 7, 2014 11:29 AM
      pegasus pegasus is offline
      VaultWiki Team
      Just made some changes this morning:

      All 3 queries are now bypassed if the request is for wiki_index.php (or whatever.php if it was renamed).
      If the request is /wiki or another rewrite path, the 3 queries are not bypassed, in case the VW_DEFAULT_SCRIPT must be used. However, if the default script is wiki_index.php, then the queries can still be bypassed, regardless if it's a rewrite or we didn't call the script directly.
      Reply Reply  
    4. March 7, 2014 12:11 PM
      pegasus pegasus is offline
      VaultWiki Team
      Implemented in the next release. If the settings are not in memory, the cache file is generated if missing, and erased if settings are saved. It contains a cache of values for the settings needed for route resolution, resulting in a savings of 1 hidden query on most page loads under vBulletin when the wiki URL format is not wiki_index.php?title=Page
      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 8:23 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.