No announcement yet.

Rebuild Search Index

  • Filter
  • Time
  • Show
Clear All
new posts

  • Rebuild Search Index

    I am running vBulletin 3.8.6 Patch Level 1

    We have about 3.9 Million Posts

    I'm trying to rebuild the search index, correct me if I am wrong.

    I set the script to execute 1000 posts at a time and each cycle takes approximately 30 seconds. At this rate the rebuild would take about 32 hours?

    ( 3900000 posts / 1000 posts per cycle ) * 30 seconds per cycle = 117000 seconds

    32.5 Hours

    Is there any way I can speed this up to do anything to ensure it completes as it failed last time sometime in the middle of the night.
    Larry D

  • #2
    Have you considered running it via command line?

    You may want to also consider sphinx - Sphinx search BETA for vBulletin 4.0

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help


    • #3
      Larry - with almost 4 million posts - you should really use Sphinx, I can give you the 3.8 product if you'd like. It will really speed up your board.
      anders | vbulletin team | check out the new vbulletin facebook app
      Proudly vBulletin'ing since 2001
      Please be my friend!
      vBulletin Performance Articles:
      Click here to read


      • #4
        I'm definitely interested; where can I obtain the 3.8 product?
        Larry D


        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.