Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #781  
Old 15 Mar 2010, 13:55
boggseric's Avatar
boggseric boggseric is offline
 
Join Date: Sep 2009
Originally Posted by TechGuy View Post
My point is that even if you can afford the $2k solution, it doesn't matter -- that solution doesn't exist.

Without reading through the entire thread, what's the status of using advanced search fields using the solution you mentioned earlier? (It was a long time ago when we last tried, but I remember we had to drop it because we couldn't sort by most of the fields.)
Sorting is definitely an issue. But from my forums perspective we had nothing to lose. The vBulletin search and MySQL search both brought our server to it's knees and frequently even crashed the server.

So we basically only had a few options:

Trim almost all of our posts and threads and put them in a different database. This seems like a good idea, but then you have to maintain two databases and do some trickery to not lose your total post count in your main forum. Then the users have to switch forums to search for something if they don't find it in the main forum. Large searches in the archive forum still eat up MySQL resources on the server and slow down the main forum.

Not allow searching at all. Not an option for us, we are a car tech forum and people MUST be able to search for data.

Continue with the vBulletin/Fulltext searches and just deal with the slow forum, crashes and angry users.

We chose sphinx, it may not be perfect but it's better than any option vBulletin has offered.
Reply With Quote
  #782  
Old 15 Mar 2010, 16:36
ivanp ivanp is offline
 
Join Date: Sep 2007
boggseric, have you tried setting up Sphinx for vB4?
Reply With Quote
  #783  
Old 15 Mar 2010, 16:59
boggseric's Avatar
boggseric boggseric is offline
 
Join Date: Sep 2009
Originally Posted by ivanp View Post
boggseric, have you tried setting up Sphinx for vB4?
Nope, I don't have any intentions of heading in that direction. I'm sure it would take a pretty hefty rewrite of sphinx_search.php.
Reply With Quote
  #784  
Old 25 Mar 2010, 14:22
Lizard King's Avatar
Lizard King Lizard King is offline
 
Join Date: Jan 2005
Real name: Mert
Originally Posted by TechGuy View Post
My point is that even if you can afford the $2k solution, it doesn't matter -- that solution doesn't exist.

Without reading through the entire thread, what's the status of using advanced search fields using the solution you mentioned earlier? (It was a long time ago when we last tried, but I remember we had to drop it because we couldn't sort by most of the fields.)
If i am not mistaken searchlight does not have any sorting issues and several user i know confirmed that . the prices were high but they have a way more attractive pricese now compared to old prices.
__________________
Mert G÷kšeimam / Crawlability Inc.

DepKaš | vBSEO 3.3.0 - vBulletin Search Engine Optimisation

Last edited by Marco van Herwaarden; 25 Mar 2010 at 15:12.
Reply With Quote
  #785  
Old 28 Apr 2010, 05:33
rsuplido rsuplido is offline
 
Join Date: May 2002
Originally Posted by ivanp View Post
boggseric, have you tried setting up Sphinx for vB4?
http://www.vbulletin.com/forum/showt...-vBulletin-4.0
Reply With Quote
  #786  
Old 01 May 2010, 11:03
R-D's Avatar
R-D R-D is offline
 
Join Date: Jan 2008
I'm not even convinced the odd sorting is that much of a bad thing. It's actually rather logical and more relevant, if you think about it. For example, you have 3 threads and you're searching for the word "cheese":

Thread 1, a thread posted to on a daily basis - the word "cheese" was posted 1 year ago.
Thread 2, a thread posted to on a weekly basis - the word "cheese" was posted 1 month ago.
Thread 3, a thread posted to on a monthly basis - the word "cheese" was posted 1 week ago.

vBulletin search would likely show the threads in the order 1, 2, 3.
Sphinx would likely show the threads in the order 3, 2, 1.

On the face of it, thread 1 hasn't been about "cheese" for a year, despite it being regularly posted to. Wouldn't a searcher looking for "cheese" find either thread 2 or 3 more relevant?


I would suggest the sorting issue with Sphinx is more about people's expectations than any actual problems. The results of a search, even for more common words, might actually be more relevant in most cases.

Just something to think about.
Reply With Quote
  #787  
Old 06 Jun 2010, 16:21
Mickie D Mickie D is offline
 
Join Date: Jun 2002
is there a plugin that will work on the 3.7 version of vbulletin.

Cant keep up with this post even though I implemented it some years ago lol.

I looked at the vb4 version to see if there was a way of implementing this on lower versions of vb3 series but there is allot of changes you will need to make, and finding the time might be a problem.

Thanks.

Mickie
__________________
Digitalworldz Satellite Cable TV Forums
Cable, Satellite, Consoles, Mobile Phones, Audio Visual, and general chat
Reply With Quote
  #788  
Old 06 Jun 2010, 17:33
ChopSuey ChopSuey is offline
 
Join Date: Jun 2009
Location: Alaska
Real name: Corey
I don't think they will downgrade the mod.
Reply With Quote
  #789  
Old 06 Jun 2010, 20:01
Mickie D Mickie D is offline
 
Join Date: Jun 2002
I have just been doing the original hack (from this post http://www.vbulletin.org/forum/showt...54#post2003154)

And I have had a nightmare adding a DATABASE PREFIX to the code lol.. taken me over 1 hour to code all the prefix's into it lol.

Anyway I have nearly got the original working with the latest sphinx, hopefully I can now get the plugins working.

Nearly there.

It would be great if they could add there advanced version (VB4) to the lower versions of vbulletin - at a guess from 3.6 - 3.8 would be almost identicle.

Where would we ask for this support anyway ?

Mickie
__________________
Digitalworldz Satellite Cable TV Forums
Cable, Satellite, Consoles, Mobile Phones, Audio Visual, and general chat
Reply With Quote
  #790  
Old 07 Jun 2010, 02:12
ChopSuey ChopSuey is offline
 
Join Date: Jun 2009
Location: Alaska
Real name: Corey
Add to the lower versions? They have wayy better things to do.
Reply With Quote
  #791  
Old 07 Jun 2010, 18:55
Mickie D Mickie D is offline
 
Join Date: Jun 2002
Originally Posted by ChopSuey View Post
Add to the lower versions? They have wayy better things to do.
That's a silly post, allot of people still use vbulletin 6, 7, 8, 9, etc.

I have 2 million posts and 70,000 members and do not want to upgrade to vb4 for many reasons but server load is the biggest factor.

Anyway I have it working now so no one has to worry about looking after customers that use a earlier version of VB

Mickie
__________________
Digitalworldz Satellite Cable TV Forums
Cable, Satellite, Consoles, Mobile Phones, Audio Visual, and general chat
Reply With Quote
  #792  
Old 09 Jun 2010, 11:36
kmike kmike is offline
 
Join Date: Oct 2002
ChopSuey, they already have a working (in production) 3.7 version, as could be seen on most of the IB auto sites. They have decided not to release it - probably to not add it to the number of reasons because of which people stay on vB 3.x.
Reply With Quote
  #793  
Old 17 Jun 2010, 13:05
kontrabass kontrabass is offline
 
Join Date: Feb 2002
Is anyone using VB4 with VB's Sphinx plugin successfully?

*chirp chirp chirp*
Reply With Quote
  #794  
Old 20 Jun 2010, 17:26
JesterP JesterP is offline
 
Join Date: Jun 2007
Originally Posted by boggseric View Post
I just set it up using the info in post 1 and the files from post 582

I used the info from this post to make sure it stayed running and this post to setup the crons for delta and nightly.

Other than that the only changes I made were from my previous post to fix the "find more posts by this user" issue.

It is now up and running on my 3.8.4pl2 forums with:
Threads: 799,861, Posts: 11,892,282, Members: 24,815

I set the max amount of of results to 20,000 and it's working great. Searches no longer take my forum to it's knees.

The things I haven't done yet are to remove the indexes from post and convert my tables to innodb.


Total cost? My time reading through this never ending thread and compiling the data above.

I wanted everyone to know boggseric's post is the way to go. Even though I read everything I could find about Sphinx, his post pulled it all together and I am now ready to convert to innodb FINALLY.

Thank you boggseric.

My setup:

Nginx for all web/PHP
Sphinx 0.9.9
vBulletin 3.8.3 80k members 740k posts

My only complaint so far is that it seems to take longer to go to a search result that's listed than clicking on anything else on the site. I'm wondering if the highlighting of the search terms the site does is causing the delay.

Thanks to everyone who contributed to this thread..... it's pure gold.

Jester
Reply With Quote
  #795  
Old 25 Jun 2010, 15:16
mute mute is offline
 
Join Date: Dec 2002
Has anyone noticed issues with "Find all posts by user" not showing all of a users recent posts? I'm not certain what's causing it, but even when my delta indexes are up to date, I'm having difficulty finding all of a users current posts. I'm not sure if it has something to do with posts being deleted or what, but it seems like it's sort of wonky.
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:15.

Layout Options | Width: Wide Color: