The Firing Line Forums - View Single Post

**tyme** · January 31, 2011, 11:23 AM

Like I said, if you want to match multiple keywords in a single post, that aren't an exact phrase, you're better of using the forum's search engine.

MySQL fulltext search is theoretically better, but it's also deathly slow. vbulletin's native search is much worse, it doesn't honor quote marks either, and it will only guarantee that some of your search terms show up in each search result.

Ideally we should support matching exact phrases too, like google, but I really cannot take on any more projects right now.

This search engine SHOULD be "matching all words", psyfly. If it isn't, give me an example search and I'll look into it. It won't match an exact phrase (that I need to look into... my plate's already way too full), but it will (should) match all your keywords. I ran a search for "savage .22 hi power" and while it didn't honor the exact phrase matching like google would, all the hits that I skimmed seemed to contain all four words.

Mal, the difference with google is that if you do that search without quotes, it will only guarantee that the four words appear on the same PAGE, not the same POST.

Mike, our search engine isn't that bad, is it? You're going to make me cry.

The other options for vbulletin are mysql's default fulltext (not an option for multiple reasons --namely that it's slow and requires myisam tables--, although it DOES do exact phrase search and proximity ranking), and vbulletin's own abortion of a search engine, which is worse on all counts.

January 31, 2011, 11:23 AM	#8
tyme Staff Join Date: October 13, 2001 Posts: 3,355	Like I said, if you want to match multiple keywords in a single post, that aren't an exact phrase, you're better of using the forum's search engine. MySQL fulltext search is theoretically better, but it's also deathly slow. vbulletin's native search is much worse, it doesn't honor quote marks either, and it will only guarantee that some of your search terms show up in each search result. Ideally we should support matching exact phrases too, like google, but I really cannot take on any more projects right now. This search engine SHOULD be "matching all words", psyfly. If it isn't, give me an example search and I'll look into it. It won't match an exact phrase (that I need to look into... my plate's already way too full), but it will (should) match all your keywords. I ran a search for "savage .22 hi power" and while it didn't honor the exact phrase matching like google would, all the hits that I skimmed seemed to contain all four words. Mal, the difference with google is that if you do that search without quotes, it will only guarantee that the four words appear on the same PAGE, not the same POST. Mike, our search engine isn't that bad, is it? You're going to make me cry. The other options for vbulletin are mysql's default fulltext (not an option for multiple reasons --namely that it's slow and requires myisam tables--, although it DOES do exact phrase search and proximity ranking), and vbulletin's own abortion of a search engine, which is worse on all counts. __________________ “The egg hatched...” “...the egg hatched... and a hundred baby spiders came out...” (blade runner) “Who are you?” “A friend. I'm here to prevent you from making a mistake.” “You have no idea what I'm doing here, friend.” “In specific terms, no, but I swore an oath to protect the world...” (continuum) “It's a goal you won't understand until later. Your job is to make sure he doesn't achieve the goal.” (bsg)