Sphinx Search

[eoc_Jason]

Guys, the bulk of the "slowdown" is/was simply the search of the post fulltext index. If your system lags doing other things (like finding all posts by username - with no query text) then you should probably look into optimizing MySQL and/or getting a little bit beefer hardware.

Searching by tag or prefix + keyword shouldn't be too much of an issue. You should be able to add tag info to sphinx and can add a conditional. Alternately you could just search the sphinx index for all results then run a seconday query afterwards pruning out the results that don't match a tag or prefix.

I do plan on upgrading to vB 3.7, so I am definitly going to make sphinx work.

[Spinball]

I think what this needs is some heroic person to go through this thread, and cherry pick the best ideas and release a full hack with complete instructions for the hopeless but enthusiastic users of Sphinx like me.

[weinstoc]

We are using Sphinx search following the instructions elsewhere in this thread (including the config file example, etc.) However phrase search does not seem to work right. If I search for "one two" I get what I would expect for "one" AND "two" instead of "one" ADJACENT TO "two".

Is there a configuration parameter that can fix this? It's quite annoying.

Chuck

[weeno]

Originally Posted by weinstoc

We are using Sphinx search following the instructions elsewhere in this thread (including the config file example, etc.) However phrase search does not seem to work right. If I search for "one two" I get what I would expect for "one" AND "two" instead of "one" ADJACENT TO "two".

Is there a configuration parameter that can fix this? It's quite annoying.

Chuck

In my limited testing of this, you would need to use Extended Query syntax:

see: http://www.sphinxsearch.com/doc.html#extended-syntax

which is a modifcation to the code (which is simple)... but then you need to be able to use quotes

"one two" for example.

And I think vb search somehow strips the quotes and doesn't get passed to sphinx, since this phrase searching doesn't work even if you turn on Extended Syntax. I was going to look into it, but never found the time.

arn

[Deriel]

Originally Posted by eoc_Jason

Guys, the bulk of the "slowdown" is/was simply the search of the post fulltext index. If your system lags doing other things (like finding all posts by username - with no query text) then you should probably look into optimizing MySQL and/or getting a little bit beefer hardware.

Searching by tag or prefix + keyword shouldn't be too much of an issue. You should be able to add tag info to sphinx and can add a conditional. Alternately you could just search the sphinx index for all results then run a seconday query afterwards pruning out the results that don't match a tag or prefix.

I do plan on upgrading to vB 3.7, so I am definitly going to make sphinx work.

I think there are people here, like me, that would be glad to donate to such project. And I do not need a "complete add-on" (ok, that would be cool), just a way to make vB 3.7 work with Sphinx with all new fluffy stuff (mainly tags and thread prefixes)

[TECK]

Originally Posted by mute

Is it me, or were they sort of insinuating that they were going to support Sphinx unofficially (like memcache) in 4.0?

Sphinx is supposed to make it into MySQL Falcon as default module, so vBulletin will support it, IMO.
I mean, why not use a good piece of software if it is part of MySQL already?

[kerplunknet]

Hey guys, what happened to the instructions to set this up with vBulletin 3.6? Did the post get removed? If anyone could provide this again or point my in the right direction, that would be much appreciated.

Thanks!

[mlx]

Originally Posted by kerplunknet

Hey guys, what happened to the instructions to set this up with vBulletin 3.6? Did the post get removed? If anyone could provide this again or point my in the right direction, that would be much appreciated.

Thanks!

The instructions are still here: https://vborg.vbsupport.ru/showpost....&postcount=387

Would be great if a moderator could add a note to the first post in the thread

[kerplunknet]

That is what I was looking for. Thank you very much

[eoc_Jason]

You have to remember though that vBulletin has to maintain backwards compability as most people are not running bleeding edge versions of PHP or MySQL. While search performance is a serious issue that the vB team has yet to address, I hope that they do offer some advanced choices for people that do know what they are doing. In short, it never hurts to hope, but don't hold you breath.

Probably next week since things will be slow and I'll be bored I'm going to download the 3.7 beta and take a look at the search code. But I'm not going to post anything based on 3.7 until it is actually released. I do plan on upgrading my forum to it as soon as it is stable / release, so you know I will be getting sphinx to work on it asap.