Search Smart Search Sphinx Smart!

Discussion in 'Managing Your Online Community' started by Vekseid, Jun 9, 2009.

  1. Vekseid

    Vekseid Regular Member

    Joined:
    Jun 2, 2009
    Messages:
    393
    Likes Received:
    13
    Any other major forum operators uses Sphinx Search here?

    It's powering Elliquiy right now, and I couldn't be happier with it. It will be powering Blue Moon before long as phpBB's searches and keyword insertions are currently responsible for most of my non-reindexing slow queries.

    The index size is a bit smaller than SMF's hashed inverted index - but larger than MySQL's native fulltext index. It's still hashed, and since it runs an actual search engine daemon, with none of MySQL's cruft, it's faster than SMF's and you can forget about fulltext trying to compete. It also supports stemming, delta indexes, and you can even weight the results according to your preferences. Also, personally, I find FULLTEXT's stopword filter to be annoying. : )

    Go ahead! Search for 'at' on Elliquiy.
     
  2. Nick

    Nick Regular Member

    Joined:
    Jul 27, 2008
    Messages:
    7,444
    Likes Received:
    219
    I wish there was a way to integrate this into vBulletin. Maybe Wayne can chime in there. :D
     
  3. Vekseid

    Vekseid Regular Member

    Joined:
    Jun 2, 2009
    Messages:
    393
    Likes Received:
    13
    There appears to be a mod here:

    Sphinx Search - vBulletin.org Forum

    However, from my reading it doesn't look like it takes significant advantage of Sphinx's abilities. It's a search engine, mind, a dedicated piece of software that powers searches. You design the indexing and selection queries yourself : )
     
  4. Wayne Luke

    Wayne Luke Regular Member

    Joined:
    Apr 2, 2009
    Messages:
    992
    Likes Received:
    276
    Official support?

    Would like to say it will be in 4.1 but can't. Don't know what specific features are being included. I guess it would depend on how the new search in vBulletin 4 works out as it has only been tested on databases with 30 million posts so far.

    I've seen demonstrations of it in use on vBulletin sites though. There is the addon at vBulletin.org but I personally haven't used it. There is also another by Teck (Floren) but he will charge you $2000.00 (and yes the decimal is in the right place) for it.
     
  5. Bundy

    Bundy Admin Talk Staff

    Joined:
    Apr 19, 2005
    Messages:
    842
    Likes Received:
    36
    Location:
    Boston
    The one on .org is junk compared to Floren's. That 2K is WELL worth it for a big board...or any board if you have the money and your board will grow. It is incredible what he has done with Sphinx Search and VB.
     
  6. Nick

    Nick Regular Member

    Joined:
    Jul 27, 2008
    Messages:
    7,444
    Likes Received:
    219
    Do you know of a site that he has implemented it on? I'd like to try it out. :)
     
  7. Abomination

    Abomination Zealot

    Joined:
    Jun 1, 2009
    Messages:
    1,514
    Likes Received:
    102
    AVS Forum

    Demo:
    [ame="http://www.youtube.com/watch?v=zJkVHcqfEBQ"]YouTube - A demo of the new Sphinx Search 2 for vBulletin at AVForums[/ame]
     
  8. Vekseid

    Vekseid Regular Member

    Joined:
    Jun 2, 2009
    Messages:
    393
    Likes Received:
    13
    "The free solution is only updated every day-"

    I should note that it's fairly trivial to add a delta index - you just define an additional source and set a cron run to recompile it every x minutes (I recompile it every 15 on Elliquiy), which gets recompiled into the main index every morning. It's your .conf file that manages multiple indexes (you can even set up an hourly and minutely delta if you want).
     
  9. Bundy

    Bundy Admin Talk Staff

    Joined:
    Apr 19, 2005
    Messages:
    842
    Likes Received:
    36
    Location:
    Boston

Share This Page