Sphinx Search

[Spinball]

Maybe we should chip in and pay someone to release a full Sphinx mod with optimisation.
I'd chip in $100 for a start.

[andrewkhunn]

Originally Posted by Spinball

Maybe we should chip in and pay someone to release a full Sphinx mod with optimisation.
I'd chip in $100 for a start.

Xorlev is already working on it for 3.7 I believe.

[Spinball]

Originally Posted by andrewkhunn

Xorlev is already working on it for 3.7 I believe.

WooHoo!

Originally Posted by TECK

Any decent programmer will not touch your site for fees like $100 per modification because those type of modifications can be done by yourself. You will not see me offering vBulletin installations or any type of minimal "hack".

Bing! You maxed out on the arrogantometer there, mate.

[TECK]

Originally Posted by Spinball

Bing! You maxed out on the arrogantometer there, mate.

It was not intended to sound arrogant. If it sounded like that, I apologize. I simply wanted to let Andrew and others that I do not deal with small code modifications, but large projects that are highly tested before they are implemented. I just finished a project for a client that had the work effort evaluated at $7,000.

If you need Sphinx search implemented, you will not get only this product, but also a set of optimizations that will improve your overall board performance by 300%. We are talking about several classes and function files what manage an agressive cache system intended to replace intensive queries performed into vBulletin. Since the search is an issue into vBulletin, you will consider this as an optimization, along with the other improvements.

This is a solution for large board owners, not the average Joe who has only one server.

[Spinball]

Teck I might be interested in your services if, now you have the code and methods written, they may be quite a lot cheaper than $7,000. How 'pluginable' are they? By which I mean would upgrading vBulletin undo your changes, or do you apply them as plugins?
And what happens when a new version of vB is installed?
Take a look at my site www.avforums.com which has usually suffered from some kind of performance problems on a regular basis.

[TECK]

Sphinx has so much potential, you can't even imagine.
I plan to do all heavy queries through Sphinx... for example the latest threads.

My new project will be similar to digg.com and will be 60% powered by Sphinx. I'm in the process of buying 4 servers (dual quad core 5410, 8Gb RAM and 2 146GB SAS 15K disks on RAID1, per server). The setup will cost me $12,000... I save $5,000 on this hardware deal. I got a really good deal on the hardware, so that's why I decided to buy 4 units, just to plan ahead. Collocation is the way I will go. Nginx will serve the data through an array of 2 servers while the DB will take the other 2.

I post those details not to show off, but to make you understand that I'm very serious about the work I do.
I don't want to be rude but the current approach to implement Sphinx is not good, IMO. I'm talking again about large forums who get hammered daily by a ton of hungry users.

[mute]

Originally Posted by TECK

Sphinx has so much potential, you can't even imagine.
I plan to do all heavy queries through Sphinx... for example the latest threads.

My new project will be similar to digg.com and will be 60% powered by Sphinx. I'm in the process of buying 4 servers (dual quad core 5410, 8Gb RAM and 2 146GB SAS 15K disks on RAID1, per server). The setup will cost me $12,000... I save $5,000 on this hardware deal. I got a really good deal on the hardware, so that's why I decided to buy 4 units, just to plan ahead. Collocation is the way I will go. Nginx will serve the data through an array of 2 servers while the DB will take the other 2.

I post those details not to show off, but to make you understand that I'm very serious about the work I do.
I don't want to be rude but the current approach to implement Sphinx is not good, IMO. I'm talking again about large forums who get hammered daily by a ton of hungry users.

Well, it may not be the optimal approach, but it's what everyone is using for lack of anything else. Without some type of sphinx implementation, we wouldn't have searching at all against our 41 million odd posts.

[amcd]

Originally Posted by mute

Well, it may not be the optimal approach, but it's what everyone is using for lack of anything else. Without some type of sphinx implementation, we wouldn't have searching at all against our 41 million odd posts.

Exactly. We have only 7 million, but the problem is significant enough.

Most of us may not be first rate programmers like TECK, but many of do know quite a bit of programming. However, being an administrator of a large board takes up so much time that there is hardly any left for programming.

[Marco van Herwaarden]

Guys,

Please do not turn this thread into advertising or discussing services offered by someone.

[Spinball]

Originally Posted by TECK

I don't want to be rude but the current approach to implement Sphinx is not good, IMO. I'm talking again about large forums who get hammered daily by a ton of hungry users.

This may be true, but stating it without offering some kind of solution (appropriate to this forum) is actually less than helpful because it unsettles people who then resent you for refusing to offer an insight into how the issues can be resolved.
It's like saying 'Oh I have the same car as you and I can make it run twice as far and twice as fast on the same gas but I'm not telling you how.' Nobody will thank you for it!