Sphinx Search

[weeno]

Originally Posted by BrandiDup

I did try to skim through most of this very long thread but the original post is gone and some of the thread is sort of confusing to me. So, can you or anyone else tell me if this is a good, stable solution that would be fairly easy for implement?

For the updating that needs to be done every 20 minutes or so, is that done by cron through vbulletin? Or do you enable it somewhere else? And, lastly, does this updating bog the server down? Every 20 minutes seems like a lot of updating but I guess it wouldn't matter if it's not that server intensive.

I'm just trying to figure out a solution that will work for us as we grow.

While we're on this subject though, is the new posts search function as server intensive as normal searches are? Nearly everyone who uses our site uses the new posts feature, so we've got no less than 100 people clicking new posts at the same time, over and over and over again. I was just wondering if this is the same as normal search or if this is something entirely different.

Thank you so much for your help.

It's not that easy a solution to implement. you have to know your way around the linux/unix command line a bit to get the solution working.

Sphinx itself needs to compiled/installed. the config file need to be modified. cron jobs added etc... all doable, but not entirely straightforward esp if you have limited experience with it. myself included, it took me a while to stumble through it myself. All the information is best summarized in these posts:

https://vborg.vbsupport.ru/showpost....&postcount=387
https://vborg.vbsupport.ru/showpost....&postcount=445
https://vborg.vbsupport.ru/showpost....&postcount=450

It does appear to be a stable solution and works very well as you can see.

The New Posts search does not appear as intensive and mine is still running through my regular mysql search and doing fine.

arn