Announcement

Collapse
No announcement yet.

Big Board Owners - Do You Use FullText Search?

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

  • Big Board Owners - Do You Use FullText Search?

    I'm wondering what the majority of Big Board owners use, the vB Search or FullText Search?

    If you don't use FullText Search, why not?
    20
    Yes
    85.00%
    17
    No
    15.00%
    3

  • #2
    Yes we do, vB search is unusable for medium+ sized boards.

    Comment


    • #3
      You might want to define what you consider 'big board' (it used to be that was a forum with over 500,000 posts, but I'm not sure if that is still the common definition).

      We have a bit over one million posts and still use vbulletin's search and we've had no problems at all (knock on wood). As for why we use it, I have just never bothered to switch.

      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 vbulletin.org
      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

      Comment


      • #4
        I am not a big-boards owner (just yet on one of my sites). But I do have fulltext search turned on. On all my forums.

        Comment


        • #5
          fulltext was killing my forums (700,000 posts - VPS 2Gb Ram) Table locking was spiking the load. Things are lot better ever since I switch back to default VB search.
          Last edited by unp; Thu 1st Jan '09, 8:14am.
          I need a drink...

          Comment


          • #6
            Originally posted by unp View Post
            fulltext was killing my forums (7K posts - VPS 2Gb Ram) Table locking was spiking the load. Things are lot better ever since I switch back to default VB search.
            With only 7,000 posts? =S

            Comment


            • #7
              Originally posted by Anthony89 View Post
              With only 7,000 posts? =S
              700,000 actually, guess bit too much wine the other day
              I need a drink...

              Comment


              • #8
                Will my database shrink in size if I switch from vB Search to FullText?

                I have 3 big boards (1mil+, 1mil+, 500k+) running on a single dedicated server and the disk space in /var is about to get full.

                Comment


                • #9
                  The data in the database itself will shrink, but the database will create indexes internally which'll be similar to what vBulletin did before with the post and word tables, so there won't really be any space savings.

                  Moving to fulltext searching isn't a solution to not having enough disk space.
                  Best Regards
                  Colin Frei

                  Please don't contact me per PM.

                  Comment


                  • #10
                    This poll is missing "I don't know".
                    selling kawaiiNation.com

                    Comment


                    • #11
                      Sphinx is great at indexing.. for some it's not a perfect solution but I've indexed a dataset of 20 million rows and the search speed is incredible, > 0.1ms for any search term (min 1 character).

                      According to their site they can support very very big text datasets, like 100gb+

                      Zend lucene is also supposed to be very good, done purely in PHP but I haven't tried that yet.
                      HP DL-380 G6, 2x E5520, 28GB RAM, 4x300GB SAS, VMWare ESXi
                      -
                      Unreal Tournament : Assault forums - irc://irc.utassault.net:6667 -

                      Comment


                      • #12
                        We've got 3,000,000 posts and use fulltext search - but we've got to find a better solution. We have noticeable hangs a couple times a week, always a fulltext search that goes to disk temp files for sorting and can run 1,800 seconds or more. The posters give up and rerun the same search over and over when results don't come back in a few seconds...

                        Comment


                        • #13
                          @Lexserv
                          Fulltext indexes are usually smaller then vBs own indexes, but as Colin already said - that's not a solution to reduce disk usage.

                          Comment


                          • #14
                            Got it. Thanks, guys.

                            Comment

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