Announcement

Collapse
No announcement yet.

Who here uses Fulltext Searching?

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

  • Bulent Tekcan
    replied
    I'm using since 2 years,and only my post table is 2.4GB

    Cheers

    Leave a comment:


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

    Leave a comment:


  • Wayne Luke
    replied
    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.

    Leave a comment:


  • Rob B
    started a topic Who here uses Fulltext Searching?

    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.

Related Topics

Collapse

Working...
X