Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #571  
Old 11 May 2008, 11:26
Jase2 Jase2 is offline
 
Join Date: Dec 2007
Anyone answer my previous question ?
Reply With Quote
  #572  
Old 11 May 2008, 11:35
ivanp ivanp is offline
 
Join Date: Sep 2007
Originally Posted by Jase2 View Post
Anyone answer my previous question ?
We are using Sphinx to replace slow vBulletin internal & fulltext search.
Reply With Quote
  #573  
Old 12 May 2008, 00:30
TechGuy TechGuy is offline
 
Join Date: Nov 2001
Real name: Mike
Has any progress been made on getting the advanced search options working?
Reply With Quote
  #574  
Old 14 May 2008, 16:25
Jase2 Jase2 is offline
 
Join Date: Dec 2007
So, it replaces the default vBulletin search ?
Reply With Quote
  #575  
Old 14 May 2008, 17:16
Deriel's Avatar
Deriel Deriel is offline
 
Join Date: May 2005
Real name: Fábio Bettega
Originally Posted by Jase2 View Post
So, it replaces the default vBulletin search ?
Yes, exactly.

Somewhere, above 1 million posts, the vB search and the Fulltext search became both too slow, too server intensive. Solution: Sphinx.
Reply With Quote
  #576  
Old 15 May 2008, 21:34
Jah-Hools Jah-Hools is offline
 
Join Date: Jul 2007
Originally Posted by Spinball View Post
I echo what you guys say. Sphinx saved our board without getting at least one more server - maybe two. Disappointing that integrating it isn't high on the vB team's priority list.
Wotcher Spinbal,

A quick question if I may.

I see you are using Google Custom search on your site..

So are you using Sphinx just for the VB Forum search?

Are most members using Google Custom as the default search? And only some using the VB search?

Thanks M8,

See - at 2 million posts search speed isnt a problem for me (so far) - what IS a problem is the forum members deep, deep unhappiness with the way the VB search works.. Google is the best way to search my forum (it handles 2 character content way better) so I am about to pull the trigger on Google Custom Business edition.. I wanted to make a last check to see if Sphinx would do the job better.. But all I can glean from these posts is 'use sphinx if VB search is slow' I don't see any raves about improved user functionality.. Does Sphinx simply improve speed for big forums and reduce the extra machines in a cluster of servers?

Its search functionality I am after.. Does Sphinx add functionality to the forum users experience - or just add speed?

Many thanks..

Last edited by Jah-Hools; 15 May 2008 at 21:39.
Reply With Quote
  #577  
Old 16 May 2008, 06:06
kmike kmike is offline
 
Join Date: Oct 2002
Yes, Sphinx produces much more relevant search results than the default vB search engines, either builtin or MySQL fulltext. It takes into account keyword proximity when calculating relevance.
I'm not sure though how it compares to Google.
Reply With Quote
  #578  
Old 16 May 2008, 12:49
Deriel's Avatar
Deriel Deriel is offline
 
Join Date: May 2005
Real name: Fábio Bettega
I think that Sphinx works better than Google CSE. You have total control over Sphinx but not over the content indexed by Google nor the time that Google takes to index new posts.
Reply With Quote
  #579  
Old 16 May 2008, 16:05
Jase2 Jase2 is offline
 
Join Date: Dec 2007
Can you still use Sphinx for a pretty small forum? I'm not a big fan of the default hehe.
Reply With Quote
  #580  
Old 30 May 2008, 14:30
Spinball's Avatar
Spinball Spinball is offline
 
Join Date: Feb 2002
Originally Posted by Jah-Hools View Post
Wotcher Spinbal,

A quick question if I may.

I see you are using Google Custom search on your site..

So are you using Sphinx just for the VB Forum search?

Are most members using Google Custom as the default search? And only some using the VB search?

Thanks M8,

See - at 2 million posts search speed isnt a problem for me (so far) - what IS a problem is the forum members deep, deep unhappiness with the way the VB search works.. Google is the best way to search my forum (it handles 2 character content way better) so I am about to pull the trigger on Google Custom Business edition.. I wanted to make a last check to see if Sphinx would do the job better.. But all I can glean from these posts is 'use sphinx if VB search is slow' I don't see any raves about improved user functionality.. Does Sphinx simply improve speed for big forums and reduce the extra machines in a cluster of servers?

Its search functionality I am after.. Does Sphinx add functionality to the forum users experience - or just add speed?

Many thanks..
I don't have details of how many people use the Google search or how. But it's a useful alternative to the Sphinx search. We can only use Sphinx for the vB forums search. I don't have the time to look at learning how Sphinx works unfortunately.
__________________
AVForums.com the UK's largest audio visual home consumer electronics forums. Now using Xenforo because vB5 is not suitable for large forums and vB3 and vB4 are no longer being developed.
Reply With Quote
  #581  
Old 31 May 2008, 23:17
eoc_Jason's Avatar
eoc_Jason eoc_Jason is offline
 
Join Date: Dec 2001
Originally Posted by Jah-Hools View Post
See - at 2 million posts search speed isnt a problem for me (so far) - what IS a problem is the forum members deep, deep unhappiness with the way the VB search works.. Google is the best way to search my forum (it handles 2 character content way better) so I am about to pull the trigger on Google Custom Business edition.. I wanted to make a last check to see if Sphinx would do the job better.. But all I can glean from these posts is 'use sphinx if VB search is slow' I don't see any raves about improved user functionality.. Does Sphinx simply improve speed for big forums and reduce the extra machines in a cluster of servers?

Its search functionality I am after.. Does Sphinx add functionality to the forum users experience - or just add speed?
One big problem with the stock vB code is that it likes to do a lot of post-filtering of the returned results. It happened way too often (to me and others) that searches where I know a keyword should appear (because I put the word in a specific place to do the test) vB will return "No results found" because it drops the score so low that it rejects it, even if it was the ONLY result...

Sphinx has it's own scoring system, and depending on how you set it up it can be extremely powerful. But if you want to gain the full benefit you will also need to probably peel through the search.php file and rip out some of the vB scoring so that it doesn't remove relevant results.

Also with sphinx it will return results in the same thread (or post) like view. So having results returned by date or a certain user or whatever is a lot more powerful than what google could probably do.
__________________
My Site: EXTREME Overclocking

Do not PM me with your iTrader problems or asking for the code. I will just delete your PM without reading it.
Reply With Quote
  #582  
Old 02 Jun 2008, 18:24
rebelde rebelde is offline
 
Join Date: Jun 2008
I was desperate to get tag search working, so I've worked it out myself. I used Orban's 0.1 "plug-in" version as a base, with Sphinx-0.9.8-rc2 on vBulletin 3.7.1. Only small changes were necessary to support tags.

I don't use prefixes in my forum, so the prefix implementation is incomplete. I just added the prefixes in the full-text index so they are searchable just like any other text in a thread or post. I would be happy to try to walk somebody (with basic PHP skills) through what I think is necessary to get it to work properly.

I have attached my versions of Orban's files. Here are the details of my changes:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

(Please excuse my new username. I haven't posted in this thread before, but I have been a member of vB.org for four years under a different username.)

And finally, thank you Orban! If you are around, turn on private messaging and I'll help however I can.
Attached Files
File Type: txt sphinx.conf.080602.txt (3.9 KB, 177 views)
File Type: txt search_sphinx.php.080602.txt (25.1 KB, 141 views)
Reply With Quote
  #583  
Old 03 Jun 2008, 09:57
orban orban is offline
 
Join Date: Jan 2005
Thanks rebelde, adding prefixes to the full text index is a great idea, I don't know why I haven't considered this. Also re-enabled PMs
Reply With Quote
  #584  
Old 04 Jun 2008, 11:21
ivanp ivanp is offline
 
Join Date: Sep 2007
Nice job orban and rebelde! It works great.

I think this code in search_sphinx.php:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

should be changed to:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Two questions:
1) Is there a fix to make wildcards work?
2) Is there a transliteration support for Sphinx?
Reply With Quote
  #585  
Old 04 Jun 2008, 14:03
rebelde rebelde is offline
 
Join Date: Jun 2008
I'm glad it is working for you.
Originally Posted by ivanp View Post
1) Is there a fix to make wildcards work?
From what I can tell from the Sphinx docs, you need to add:
min_prefix_len = 3
prefix_fields = title (maybe more?)
enable_star = 1

I'm not sure where you add these lines, though. I would think that they go in:
index thread : post - first two
index threaddelta : post - first two
searchd - enable_star = 1

Let us know if you find out where they go, and if it slows searches much.

Transliteration? I'm not sure. Check the Sphinx docs.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 22:16.

Layout Options | Width: Wide Color: