Announcement

Collapse
No announcement yet.

Who here uses Fulltext Searching?

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

  • Who here uses Fulltext Searching?

    If you do, what were your experiences when changing to it, to what extent did it reduce the size of your database, does everything work exactly as it did using the vBulletin search or are there things that don't work or don't work as well?

    I am trying to minimize the size of my database without having to resort to pruning, my forum has only been up 8 or 9 months and is 190MB.

    Cheers.

  • #2
    Fulltext searching is not intended to be a feature that reduces the size of the database. What you lose in the word and postindex tables, you gain in indexes on the post and thread tables.

    What it can do, on a properly configured server, is reduce the resources used by searching a large forum site.
    Translations provided by Google.

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

    Comment


    • #3
      Fulltext is very performant...at least much more than SELECT * FROM whatever LIKE '%whatever%'

      Comment


      • #4
        I'm using since 2 years,and only my post table is 2.4GB

        Cheers

        Comment

        Related Topics

        Collapse

        Working...
        X