Rebuild search index

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Craig
    Senior Member
    • Jan 2008
    • 996
    • 6.X

    Rebuild search index

    How does the rebuild index process work?

    Is there a way to rebuild a search index without maxing out db query limits (for me its 300,000).

    The problem im running into is i get a server timeout before the rebuild is completed, and im sure it doesnt start from where it left off.
    adktramping ~ my happy place.

    "Whoever said practice makes perfect was an idiot. Humans can't be perfect because we're not machines." ~ Sam Gardner.

    Vote for your favorite feature requests and the bugs you want to see fixed.
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    #2
    Rebuilding the search is database intensive. There is no way to reduce the number of queries except by offloading it to SphinxSearch. The command line rebuild script, searchindex.php, is more resource friendly than the AdminCP version.

    When you run the search and do not empty it, it should notice if something is indexed and skip to the next item. It may take a while to find nodes that aren't indexed but it doesn't undo the work already done. To restart from the beginning, you can tell it to empty the search index when you run it. In the AdminCP you can also tell it to start at a specific number. So you can reindex the newest nodes first if you want to do that.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • Craig
      Senior Member
      • Jan 2008
      • 996
      • 6.X

      #3
      Can you do it individually by content type as well?
      adktramping ~ my happy place.

      "Whoever said practice makes perfect was an idiot. Humans can't be perfect because we're not machines." ~ Sam Gardner.

      Vote for your favorite feature requests and the bugs you want to see fixed.

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 73981

        #4
        Within the AdminCP, there is an option to reindex specific content types.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        • Craig
          Senior Member
          • Jan 2008
          • 996
          • 6.X

          #5
          Perfect, thank you!

          What is the rationale of the time at the bottom of that module? What does it actually represent?
          adktramping ~ my happy place.

          "Whoever said practice makes perfect was an idiot. Humans can't be perfect because we're not machines." ~ Sam Gardner.

          Vote for your favorite feature requests and the bugs you want to see fixed.

          Comment

          • Wayne Luke
            vBulletin Technical Support Lead
            • Aug 2000
            • 73981

            #6
            The number of seconds to process that batch.
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API

            Comment


            • Craig
              Craig commented
              Editing a comment
              Thank you for clarifying!
          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...