vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=127868

boggseric 15 Mar 2010 14:55

Quote:

Originally Posted by TechGuy (Post 2004032)
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.

ivanp 15 Mar 2010 17:36

boggseric, have you tried setting up Sphinx for vB4?

boggseric 15 Mar 2010 17:59

Quote:

Originally Posted by ivanp (Post 2004141)
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.

Lizard King 25 Mar 2010 15:22

Quote:

Originally Posted by TechGuy (Post 2004032)
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.

rsuplido 28 Apr 2010 06:33

Quote:

Originally Posted by ivanp (Post 2004141)
boggseric, have you tried setting up Sphinx for vB4?

http://www.vbulletin.com/forum/showt...-vBulletin-4.0

R-D 01 May 2010 12:03

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. ;)

Mickie D 06 Jun 2010 17:21

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

ChopSuey 06 Jun 2010 18:33

I don't think they will downgrade the mod.

Mickie D 06 Jun 2010 21:01

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

ChopSuey 07 Jun 2010 03:12

Add to the lower versions? They have wayy better things to do.

Mickie D 07 Jun 2010 19:55

Quote:

Originally Posted by ChopSuey (Post 2049672)
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

kmike 09 Jun 2010 12:36

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.

kontrabass 17 Jun 2010 14:05

Is anyone using VB4 with VB's Sphinx plugin successfully?

*chirp chirp chirp*

JesterP 20 Jun 2010 18:26

Quote:

Originally Posted by boggseric (Post 2003154)
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

mute 25 Jun 2010 16:16

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.


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

Powered by vBulletin® Version 3.8.14
Copyright © 2021, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.