Announcement

Collapse
No announcement yet.

vbulletin search engine vs mysql fulltext search?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • vbulletin search engine vs mysql fulltext search?

    maybe it was discussed already, i couldn't find it.

    what are the advantages and disadvantages of the two search methods?
    i only care about speed and serverload, not about the couple of megs the postindex and word-table use

    thanks for any informations

    sorry for my bad english I hope, you understand me anyway

  • #2
    FULLTEXT search is faster and less server intensive then the old postindex/word-table version

    Comment


    • #3
      ... and is the only method that can work for bigger boards (several million posts).

      Comment


      • #4
        They are both sort of correct,

        Fulltext - natural language, is way faster and less intesnive than the old vB method, but Boolean is / can be intensive depending.

        Comment


        • #5
          should i disable Index New Posts in Search Engine when i only use mysql fulltext?

          Comment


          • #6
            Originally posted by le`shaq
            should i disable Index New Posts in Search Engine when i only use mysql fulltext?
            dont care as i cant post!

            Comment


            • #7
              The way I understand it, yes, as it's not needed anymore.
              On the other hand I could imagine that posts aren't indexed anymore anyhow.
              Best Regards
              Colin Frei

              Please don't contact me per PM.

              Comment


              • #8
                So we can disable Index New Posts?

                Comment

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